IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
How to Access and Read Planning Analytics for Excel Log Files
When Planning Analytics for Excel (PAfE) connects to your TM1 server, it's constantly working behind the scenes — making API calls to retrieve data, refresh reports, and keep your models in sync. Most of the time, this happens without a hitch. But…
July 7, 2026
IBM Planning Analytics Tips & Tricks
Goodbye Excel Groupings, Hello Toggle Buttons: A PAfE Win for Web Reports
Have you ever been in a situation where you have a very wide Excel report and want to allow your users to minimize the columns that appear? If so, one of the options at your disposal is the ability to group columns. This…
June 23, 2026
IBM Planning Analytics Tips & Tricks
How to Use Diff View in IBM Planning Analytics Workspace to Track TI Script Changes
Have you ever been in a situation where you have a long TI script and need to change a few lines. You plan out the steps, make the first change, get ready for the second, and then hear the phone ring. After…
April 14, 2026
IBM Planning Analytics Tips & Tricks
How to Handle Outliers in IBM Planning Analytics Predictive Modeling
Have you used Planning Analytics to generate a forecast and realized that your data might not be as clean as you wanted? Maybe the data is legitimately skewed, such as the massive swings that occurred during COVID. Or maybe the data has…
March 24, 2026
IBM Planning Analytics Tips & Tricks
Celebrating Pi Day with Excel’s =PI() Function
As you know from reading my previous blogs (The Hidden Structure of 1/7 and Exploring Consecutive Squares with 9/16/25), I am a big fan of combining math with dates. This week allowed us to celebrate another math date! Pi Day (March 14th) was just…
March 17, 2026
IBM Planning Analytics Tips & Tricks
Use the Planning Analytics AI Assistant for Smarter Data Analysis
Have you used Planning Analytics’ new AI functionality to analyze your existing models? Maybe you have a chart that you want to get insights on, or maybe you have a set of data where you want to define outliers. All this functionality…
March 10, 2026
IBM Planning Analytics Tips & Tricks
The Fastest Way to Copy a Worksheet in Excel
Many Excel users copy worksheets by right-clicking on the tab, choosing Move or Copy, and then checking Create a copy. While that works, there’s a much faster way to duplicate a worksheet in seconds. Here’s the shortcut: 1. Hold down the Control…
February 17, 2026
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…