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…
December 21, 2021
Technical Bulletin: Update to Log4j Vulnerability’s Impact on IBM Planning Analytics
Updated December 21, 2021 Summary Multiple vulnerabilities have been discovered involving Apache Log4j. This was originally known as CVE-2021-44228, but it has been expanded to also include both CVE-2021-45046 and CVE-2021-45105. Apache Log4j is used by IBM Planning Analytics Workspace as part of its…
December 21, 2021
Technical Bulletin: Apache Log4j Vulnerability Impact on IBM Planning Analytics Models
Summary A vulnerability has been discovered involving Apache Log4j (CVE-2021-44228). Apache Log4j is used by IBM Planning Analytics Workspace as part of its logging infrastructure. This may have a significant impact on your existing models. Details This issue impacts all users currently…
December 15, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Maps
IBM Planning Analytics Workspace (PAW) version 69 introduced a new map visualization for your charts. In addition to improving the identification of the geography elements, this new visualization introduces additional features such as … The ability to search for locations within the…