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 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 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: 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
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…