IBM Planning Analytics Tips & Tricks
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.…
January 21, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Export Data
While IBM Planning Analytics is an excellent database that allows you to easily slice and dice your data, there may be situations where you want to export data from the model. Maybe you want to share information with someone who uses different…
January 14, 2025
IBM Planning Analytics Tips & Tricks
A Resolution You Should Actually Keep: Upgrade Your IBM Planning Analytics Environment
Did you know that almost 80% of all New Year's resolutions are associated with health? As an IBM Planning Analytics user, it's important to also think about your system's health! This is why you should put "upgrading Planning Analytics" on your list…
January 7, 2025
IBM Planning Analytics Tips & Tricks
Popular IBM Planning Analytics Videos of 2024
We all love analytics, right? We took a look at the analytics on our videos to see which ones you and your peers watched the most. Here are our most popular IBM Planning Analytics videos – both on-demand webinars and Tips &…
December 31, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Export Dim Structure
Have you ever wanted to export a dimensional structure to an ASCII based text file in IBM Planning Analytics Workspace (PAW)? PAW version 99 introduced the ability to export a dimension with a single click. To export a dimension, right-click on the…
December 17, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Selector Menu
You may already know that you can create a selector widget in IBM Planning Analytics Workspace (PAW) by simply dragging a context dimension outside your existing view. Once synchronized, this approach provides an easy way to create independent selectors that can be…