Welcome to Revelwood’s Knowledge Center
Excel Users Embrace IBM Planning Analytics
Microsoft Excel is the tool CFOs and finance professionals love to hate. The problem is often a result of trying to use Excel for complex financial planning and analysis. Excel is simply the wrong tool for that job. In fact, a BARC…
July 16, 2018
Nucleus Research Finds IBM’s Corporate Performance Management Solutions Focus on Personal Functionality and Usability
Nucleus Research’s “CPM Technology Value Matrix 2017” named IBM a leader in Corporate Performance Management (CPM) solutions and found that “recent changes to its CPM products focus both on personal functionality and usability, empowering a greater diversity of individual users with more…
July 11, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Year-to-Date Hierarchies
Did you know you can create a single hierarchy that contains all year-to-date values within an entire year? As you know, TM1 is a consolidation tool which is designed to sum together a series of values. There are many ways to create…
July 10, 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
Top 5 IBM Planning Analytics Tips & Tricks
Every week we publish a new blog post on IBM Planning Analytics Tips & Tricks. Some of these focus on how to use new features in IBM Planning Analytics and others explain how to optimize key aspects of the core TM1 engine.…
June 25, 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
Embracing Continuous Planning
The old school annual budgeting and planning process is just that – old school. Today’s forward-thinking FP&A executives, managers, and analysts instead are embracing continuous planning and rolling forecasting. Rolling forecasting is the process of simulating profit and loss for a company…