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…
September 11, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using Attributes
Did you know that element attributes in TM1 and IBM Planning Analytics can be used for more than just making report aliases? They can be utilized by the system itself to better manage data flow, and to make it easier to trace…
September 4, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: String Feeders
Did you know feeding based on string values can be tricky? Anyone that has developed in TM1/IBM Planning Analytics before knows full well the importance of a well-written feeder statement. An example of this is when we have a cube with string…
August 28, 2018
IBM Planning Analytics Tips & Tricks
Working With Windows Directory Junctions in IBM Planning Analytics & TM1
This is a guest post from Revelwood's Shane Bethea. Did you know you can create a new path to an existing Windows folder without breaking the original path when working in IBM Planning Analytics and TM1? An example of this is when you…
August 21, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Creating a Simple Dashboard in Planning Analytics Workspace
Did you know it's easy to create a simple dashboard in IBM Planning Analytics Workspace? IBM Planning Analytics Workspace dashboards allow you to provide quick and effective information to the end user. The following steps demonstrate how to create a simple dashboard.…
August 14, 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 for unsupported Excel functions in TM1 Web? Have you ever published a TM1 Web report, only to see repeating #NAME errors when you access the report online? These are typically caused by unsupported…