IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: HTTPPORTNUMBER
Did you know that when you create a new TM1 / IBM Planning Analytics Local (PAL) 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…
June 6, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Posts, Part 2
Earlier this month we shared three of our most popular IBM Planning Analytics Tips & Tricks blog posts. Since we publish these tips & tricks posts every Tuesday, we have plenty of tips you might have missed. Here are three more of…
May 30, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Set Editor Remove Duplicates
In a recent blog post, we explained how to use Excel to produce a list of unique values. But what if you wanted to do the same thing in your subset? IBM Planning Analytics Workspace (PAW) version 82 introduced an approach into…
May 23, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Posts, Part 1
Revelwood’s IBM Planning Analytics team covers a wide range of topics in their weekly IBM Planning Analytics Tips & Tricks posts. We’ve decided to share some of the most popular posts over the past 12 months. IBM Planning Analytics Tips & Tricks:…
May 16, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Run TI Processes from PAx Task Pane
Did you know that you can run TurboIntegrator (TI) processes via the task pane in Planning Analytics for Excel (Pax)? Within the task pane, you can choose to display processes by clicking on the “Show and Hide” button and selecting the option…
May 9, 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 & Tricks: Excel Tips, Part 4
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. For the past few weeks, we’ve been highlighting some of the most popular and interesting posts on Excel. If you’ve missed our earlier posts, read…
April 25, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Users and Groups
Do you know how to manage your users and groups in IBM Planning Analytics Workspace (PAW)? As of version 84, PAW now allows you to edit this information via a single click. To open the users and groups editor, right-click on a…
April 18, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel Tips, Part 3
Revelwood’s IBM Planning Analytics team has created numerous tips & tricks focused on helping people use Excel. Over the next few weeks, we’ll be highlighting some of the most popular and interesting posts on Excel. If you’ve missed our earlier posts, read…