
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: Planning Analytics Workspace Process Editor Function Help
Do you know how to use the function help button when developing processes in IBM Planning Analytics Workspace (PAW)? Within the scripting editor there is an fx button on the far-right hand side of the screen as seen below. When the button is…
April 12, 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: PASS Version Numbering
IBM released version 73 of IBM Planning Analytics Spreadsheet Services (PASS), formerly known as TM1 Web, on February 10, 2022. This version includes a few design improvements associated with stylesheets and sorting. The main change, however, is associated with the version number. The February…
March 1, 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: Modeling Books
Did you know IBM Planning Analytics Workspace (PAW) update 57 introduced a new type of PAW book? This new type of book is called a “Modeling Book.” A modeling book can be created by selecting the “Data and Models” tile at the…