IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating Buttons in Planning Analytics Workspace (PAW)
This is a guest post from Revelwood's Shane Bethea. Did you know there's an easy way to create buttons that allow your users to switch sheets in IBM Planning Analytics Workspace (PAW)? For example, you’ve created multiple sheets in a PAW book…
December 11, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Duplicating Sheets
This is a guest post from Revelwood's Shane Bethea. Did you know IBM Planning Analytics Workspace (PAW) has a new feature that lets you easily duplicate sheets? Have you ever created a template or dashboard in PAW and thought, “This is a…
December 4, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Setting Default Members
Did you know IBM Planning Analytics has a new function called “Default Members?" This is different from default subsets. Default members are what is used if you were to simply drag a dimension into a Planning Analytics for Excel (PAx) sheet or…
November 27, 2018
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: 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 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: 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: 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…
September 25, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Conditional Feeders
Did you know IBM Planning Analytics can minimize the amount of feeder data via an approach called a "conditional feeder?" A conditional feeder is exactly what it sounds like - it only feeds when a certain condition is met. In a previous…