IBM Planning Analytics Tips & Tricks
How to Remove Duplicate Elements from an Existing Subset in Planning Analytics Workspace
Managing large datasets in IBM Planning Analytics Workspace (PAW) often means dealing with complex lists of elements—from thousands of SKUs to extensive customer databases. In this edition of our IBM Planning Analytics Tips & Tricks series, Lee Lazarow, IBM Planning Analytics Practice…
February 3, 2026
IBM Planning Analytics Tips & Tricks
How to Create Picklists in Planning Analytics Workspace
Creating picklists in IBM Planning Analytics Workspace (PAW) is a simple yet powerful way to control user input and improve data consistency. In this edition of our IBM Planning Analytics Tips & Tricks series, Lee Lazarow, IBM Planning Analytics Practice Leader at…
January 20, 2026
IBM Planning Analytics Tips & Tricks
Performance Monitoring in Planning Analytics Workspace
Keeping your IBM Planning Analytics environment running efficiently is critical as models grow, data volumes increase, and user activity expands. In this edition of our IBM Planning Analytics Tips & Tricks series, Lee Lazarow, IBM Planning Analytics Practice Leader at Revelwood, walks…
January 6, 2026
IBM Planning Analytics Tips & Tricks
Exploring Consecutive Squares in Today’s Date: 9-16-25
Sheldon Cooper may like to have fun with flags, but I prefer a different approach: fun with dates! In my periodic (and made-up) series, I previously wrote blogs about the use of Excel’s DATE function and about July 1. Today is September…
September 16, 2025
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: 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…