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.…
June 6, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TI Dimension Functions
Have you ever updated a dimension in the Prolog of your TurboIntegrator (TI) script and then received errors when making further changes to the dimension in the Metadata section? This is because certain dimension altering functions such as DIMENSIONELEMENTINSERT are not evaluated…
May 2, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Upgrading to Planning Analytics for Excel 2.0.65 or later
As of version IBM Planning Analytics version 2.0.65, you can choose to either launch IBM Planning Analytics for Excel (PAx) as a single session (by double-clicking the .XLL file) or load it as an add-in (and have it available for all Excel…
March 21, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Beginning to Explore the Set Editor in Planning Analytics for Excel
The IBM Planning Analytics Set Editor is the equivalent to the TM1 Subset Editor for Architect and Perspectives, but with expanded functionality. Getting started with the set editor is as simple as double clicking on a dimension within your exploration. In this…
September 13, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Data Integration and the Planning Data Source
Did you know that Workday Adaptive Planning integrations can use the metadata in Adaptive Planning as a part of the integration? It’s true! The process requires setting up the credential and setting up a data source for Adaptive Planning. You must have…
August 17, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding and Editing Connection URLs in Planning Analytics for Excel
Do you know how to add a new Connection URL or Edit an existing Connection URL in Planning Analytics for Excel? Here are the steps to follow: Adding a Connection URL Once Planning Analytics for Excel has been launched, go into the…
August 2, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Data Integration and the Excel Spreadsheet Data Source
Did you know that Workday Adaptive Planning can use Microsoft Excel Workbooks as Data Sources for Data Integration? It’s true! The process is surprisingly simple if a few basic rules and steps are followed: Your column names, positions, and formatting should remain…
July 20, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Process Editor Function Help
Do you know how to use the function help button when developing processes in IBM Planning Analytics Workspace (PAW)? Within the scripting editor there is an fx button on the far-right hand side of the screen as seen below. When the button is pressed, a…