IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Picklists
You may have read our previous blog posts about creating picklists in IBM Planning Analytics and using them in the Planning Analytics Workspace (PAW) interface. PAW version 101 introduced the ability to easily create picklists from a view. This is done by…
July 15, 2025
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Tips and Tricks: Data Integration and Creating a Join Table
Did you know that Workday Adaptive Planning integrations allow you to create joined tables to be used as a source table in Adaptive? It’s true! The process involves creating and defining the join between tables. You must have the proper credentials yourself…
July 9, 2025
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Attributes Types
Do you know how to see attributes and attribute types in IBM Planning Analytics Workspace (PAW)? While in the dimension editor, click on the tab that says Attributes. The attributes will be presented to the right of the elements. But how do…
June 17, 2025
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
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: How to Filter Data for Sage Intacct Integrations within Adaptive Staging Tables
There are many times when importing data into the staging tables for Sage Intacct integrations that I am looking for just a subset of data and not all the data. Importing everything takes time, and if you filter your retrieval in the…
May 15, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Asymmetrical Expand in PAW
Have you ever been in a situation where you have stacked dimensions in your view and only want to expand one section of it? In legacy Perspectives, an expansion of one area equates to an expansion of all areas. IBM Planning Analytics…
April 30, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Trusting the Directory where the Planning Analytics for Excel xll file resides
Have you ever received a notification from Excel stating that it was having an issue trusting the Planning Analytics for Excel (PAfe) Add-In? If so, you are not alone! From time to time, it seems Excel needs to be reminded that the…
October 3, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Expanding Sections of Stacked Dimensions
Have you ever been in a situation where you have stacked dimensions in your view and only want to expand one section of it? In legacy Perspectives, an expansion of one area equates to an expansion of all areas. IBM Planning Analytics…
July 25, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: HTTPPORTNUMBER
Did you know that when you create a new TM1 / IBM Planning Analytics instance that the HTTPPORTNUMBER parameter is required? This setting is placed within the TM1S.cfg file for your model. Some things to note when defining the HTTPPORTNUMBER parameter: 1.…