IBM Planning Analytics Tips & Tricks
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…
April 29, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Workspace Settings: DIM Editor Page Size
Have you ever edited a large dimension in IBM Planning Analytics Workspace and found that you are forced to repeatedly scroll through a list to see the full dimension? This may be because you are only looking at 200 elements at a…
April 15, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Workspace Settings – Dim Editor Index
Have you ever looked at all elements in a dimension (via the “All” button in Perspectives or any of the prebuilt “All xxx” sets in IBM Planning Analytics) and wondered how the resulting order was defined? This is a result of a…
April 1, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Application Websheet Folders
As you migrate from IBM Planning Analytics’ TM1Web to Planning Analytics Workspace (PAW), you may be asking yourself if you can still create folders to organize your websheets. The answer is yes! Name change Planning Analytics no longer refers to the folders…
March 18, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Rename Views in PAfE
Have you ever been in a situation where you saved a view and then realized that you want to change the name in IBM Planning Analytics for Excel (PAfE, formerly PAx)? Maybe you had a typo or maybe you referenced a date…
March 4, 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: Update on Planning Analytics’ Deprecation
IBM recently made the End of Support dates for Planning Analytics 2.0.9.x official. As we mentioned in our previous blog post on the deprecation of Planning Analytics 2.0.9.x, IBM is extending the general support period for Planning Analytics 2.0.9.x until October 31,…
February 4, 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.…