IBM Planning Analytics Tips & Tricks
Accessing PAX Exploration Headers in Excel
Explorations are a great way to perform ad-hoc analyses in your IBM Planning Analytics for Excel (PAfE) environment. However, the title selections in the Exploration ribbon are not directly accessible. Here is an approach to access the title selections and make your…
November 4, 2025
IBM Planning Analytics Tips & Tricks
TM1SET Excel Formula
The TM1SET Excel formula is similar to the SUBNM formula except that TM1SET is hierarchy aware and has formula reference traversal. The syntax for TM1set is: TM1set(uri_identifier,serverName,dimensionName,hierarchyName,setExpression,selectedElement,sessionSetOut,activeDisplay,displayModeEnum) Follow these steps to build a file with the TM1SET formula. 1 – In a…
October 21, 2025
IBM Planning Analytics Tips & Tricks
The TRIMRANGE Excel Formula
Have you ever referenced an entire row or column and wondered if Excel is doing too much additional processing? If so, the TRIMRANGE formula can help! The TRIMRANGE formula makes your Excel file more efficient by removing extra rows and columns from…
October 7, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: MDX to Copy a View
As a model developer, it’s very important to have separate development and production environments that replicate each other as much as possible. This sometimes leads to a situation where you may need to create the same view in both environments. In situations…
August 26, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Settings – File Upload Action Button
Have you ever written a TurboIntegrator (TI) script that used a manually uploaded file as a source? If so, this requires a two-step process: upload the file and then run the script. As long as you remember to follow both steps, the…
May 27, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW – Navigation Approaches Using Action Buttons
Have you ever been in a situation where you created a multi-tab IBM Planning Analytics Workspace (PAW) book that required a combination of inputs, TurboIntegrator (TI) processing, and the viewing of results? If so, you may have created a two-part workbook that…
April 29, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s AGGREGATE Function
Excel’s AGGREGATE function lets you manage complex reports and ensure they foot correctly. For example, suppose you are building a sales report by product and region. Building the Grand Total calculation for a multi-level report like this is error-prone. You would need…
February 18, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Unpivot
Did you know you can unpivot data in IBM Planning Analytics? Sometimes you’ll find yourself in a situation where you need to change the layout of data from a grid format to a vertical table format, this is called unpivoting the data.…
January 21, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: VSTACK_HSTACK
In a previous blog, I wrote about the ability to convert a list into a set of smaller lists (create a link to the WRAPCOLS blog). But what if you wanted to do the opposite? What if you wanted to merge a…