IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Changes to Eight Planning Analytics Server Configuration Parameters
This is a guest post from Revelwood's Jay Apwah. Did you know that since IBM Planning Analytics was released on the cloud, there have been changes to IBM Planning Analytics server configuration parameters? New parameters have been introduced, existing ones have had…
November 20, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Synchronizing Selectors with Planning Analytics Workspace
Did you know that you can easily synchronize your selectors with your IBM Planning Analytics Workspace (PAW) components? PAW allows you to synchronize your widgets to a selector or set of selectors. This ensures that a change in your selected elements impacts…
November 13, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Workarounds for Unsupported Excel Functions in TM1 Web
Did you know there are a number of workarounds available for Excel functions that are not supported by TM1 Web? This blog post is the second in a series discussing these workarounds. Below, I’ll describe ways to accomplish the same results using functions…
November 6, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Selectors in Planning Analytics Workspace
Did you know that there are different ways to create selectors in IBM Planning Analytics Workspace (PAW)? TM1 Perspectives allows you to create selectors via the SUBNM formula. This approach offers an easy way to create a selectable list on a report…
October 30, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Dynamic Sets in the PAx Set Editor
This is a guest blog post from Revelwood's Shane Bethea. Did you know that you can use the IBM Planning Analytics for Excel (PAx) Set Editor to create dynamic sets to be used in a view? This can be accomplished by using…
October 23, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Writing Rules
Did you know that that way you write your rule could impact the performance of the model in IBM Planning Analytics? There are three parts to a rule. The area definition describes the section of the cube to which the rule will…
October 16, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Recalculating Excel Worksheets
Did you know there are various shortcuts to force calculations in Excel, and that there is a shortcut that does this for TM1 Perspectives and Planning Analytics for Excel (PAx) as well? Rather than searching for a button in the Excel ribbon,…
October 9, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Hiding Dimensions in Planning Analytics Workspace
Did you know that you don’t have to show all of your dimensions during an ad-hoc query in IBM Planning Analytics Workspace (PAW)? TM1 cube views and formulas require a reference to every dimension within the cube. While all of these dimensions…
October 2, 2018

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Replace and Close Feature in PAx
This is a guest blog post from Revelwood's Shane Bethea. Did you know that the IBM Planning Analytics for Excel (PAx) Set Editor has a new, simplified way of selecting dimension elements for a view? As of PAx version 2.0.34, this can…