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: 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
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: Three Reserved Local Variables in TurboIntegrator
This is a guest post from Revelwood's Jay Apwah. Did you know that there are reserved local variables that you can use in TurboIntegrator scripts? Reserved local variables are variables that do not need to be defined and are destroyed when the…
July 3, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1 Web Writeback Protection
This is a guest post from Revelwood's Shane Bethea. Did you know that you can prevent data entry to TM1 in TM1 Web websheets? Here are a couple of different ways to do this. The first approach can be used for input…
June 26, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics for Microsoft Excel (PAx) VBA API Calls
This is a guest post from Revelwood's Shane Bethea. Did you know IBM Planning Analytics lets you make API calls through VBA in Planning Analytics for Microsoft Excel (PAx)? You probably know that action buttons can be used to refresh or rebuild…
June 19, 2018
Tech Bulletin: PAx Incompatibility Caused by Latest Microsoft Office Update
This is a technical bulletin from Revelwood's Steve Ellis. Did you know that the latest version of Microsoft Office 365 caused Planning Analytics for Microsoft Excel (PAx) to become unusable? I will show you how to determine if you have been impacted…
June 18, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Make Action Button Messages Dynamic
This is a guest post from Revelwood's Jay Apwah. Did you know that in Planning Analytics for Microsoft Excel (PAx) and Perspectives you can customize action button messages? Well you can go one step further and make those messages dynamic. In this…
June 12, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Impact of Consolidations in Feeder Statements
This is a guest post from Revelwood's Stephen Ellis. Did you know writing feeders in TM1 is one of the more difficult tasks for any developer? One of the questions I am asked most often is “How do I know if I’m…