IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Focus Cell
As you all know, Excel performs subtle formatting when you click on a cell to graphically show you both the row and column of your cell. For example, if I click on cell B3 then Excel will highlight the headers in column…
August 12, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Default Settings
Do you sometimes find yourself repeatedly changing your IBM Planning Analytics Workspace (PAW) settings within the view screen, the dimension editor screen, or other areas of PAW? Did you know that you can define your own defaults for many of these settings?…
July 29, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Picklists
You may have read our previous blog posts about creating picklists in IBM Planning Analytics and using them in the Planning Analytics Workspace (PAW) interface. PAW version 101 introduced the ability to easily create picklists from a view. This is done by…
July 15, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Hidden Structure of 1/7: A Mathematical Perspective
Today is July 1. It’s the first day of the second half of the year and it’s also international chicken wing day. But for the purposes of today’s blog, none of that matters. What matters is that the reciprocal of 7/1 is 1/7, which…
July 1, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Attributes Types
Do you know how to see attributes and attribute types in IBM Planning Analytics Workspace (PAW)? While in the dimension editor, click on the tab that says Attributes. The attributes will be presented to the right of the elements. But how do…
June 17, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Rule Auto Complete Display
There are various ways to use the IBM Planning Analytics Workspace (PAW) rules auto-complete feature to help you create rules in your environment. For example: when referencing a specific element, you can simply type a left bracket and a single quote to…
June 3, 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: Search with Descendants
The IBM Planning Analytics subset editor includes various options to search a list of elements within a dimension. This includes the ability to search by name and attribute, search by referencing mathematical comparisons or text searches and search by one filter or…
May 13, 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…