
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function
Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…
June 21, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors
One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…
June 14, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: NumberToStringEx
IBM Planning Analytics has the ability to export data to flat files with the use of the ASCIIOUTPUT and TEXTOUTPUT functions. However, these two functions will only accept string variables. That means that numeric data will first need to be converted to…
June 7, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Refresh PAW Visualizations Automatically
Did you know that you can have IBM Planning Analytics Workspace (PAW) visualizations refresh automatically? To enable this setting, first make sure you are in “Edit” mode within your PAW book. You can then click on your visualization then click “Properties” in the…
March 29, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Improve Workbook Performance
Did you know that defined name ranges can impact IBM Planning Analytics for Excel (PAx) report performance and the performance of Excel workbooks and worksheets themselves? It’s true! When workbooks are reused repeatedly for reporting purposes, defined worksheet names are stored within the…
March 22, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Updating ODBC Connections for Multiple Processes
As of version 2.0.69 of IBM Planning Analytics Workspace (PAW), you are now able to update the ODBC connection for multiple TurboIntegrator (TI) processes at once. For prior versions, you would have needed to open each process to update the connection. To utilize…
February 8, 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…
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: 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…