IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s XMATCH Function
Have you ever wanted to search a list and define the position where it appears in the list? Maybe you want to know how many sales reps exceeded their quota or want to define how many products cost more than an approved purchase…
May 17, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Workbook Stats
Have you ever wanted to know details about your existing worksheet or workbook such as the number of cells that contain data or the number of total sheets? In 2021, Microsoft Excel introduced a feature called Workbook Statistics that will provide details about…
May 3, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Unhide Multiple Excel Sheets
As you know, an Excel workbook can consist of multiple sheets. There are many instances where you may want to hide some of the sheets. It’s very fast and easy to hide sheets, but Excel historically allowed you to unhide only one sheet at…
April 5, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Stacked Rows in PAx
Have you ever converted a stacked Perspectives view into a Dynamic report? If so, you may have noticed the way Excel formats the outside of your stack. For example, if I use the Active Form button to send the following view to…
March 8, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel OFFSET Function
Have you ever wanted to reference a cell based on its placement compared to another cell? Maybe you want to create a formula where each cell looks at the value 2 columns to the right or maybe you want to compare a…
February 22, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx – Rebuild Book vs Recreate Book
Are you familiar with the difference between the “Rebuild Book” button and the “Recreate Book” button in IBM Planning Analytics for Excel (PAx)? Both buttons are used to update the rows which appear on your Dynamic Reports and both buttons refresh the…
February 15, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The SCAN Function
Have you ever needed to parse data by looking for a specific character within your source records? Maybe you want to filter an employee’s last name from a “Lazarow, Lee” or maybe you want to define the year from “12/25/2021”. All of…
January 25, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Combining the DIMIX and DIMNM Functions
In a previous blog, we defined how to convert an alias back to the original element name within a TurboIntegrator script. The DimensionElementPrincipalName function is only valid for TI scripts, so what happens if you need to perform the same logic in a…
January 11, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator
Have you ever needed to convert an alias back to the original element name within an IBM Planning Analytics TurboIntegrator script? Maybe you have a data source where the value entails an alias but further logic references the element code. You can…