Welcome to Revelwood’s Knowledge Center
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
New Report Details Finance’s Adoption of Automation
CFOs in companies of all sizes are assessing how, when and where they should automate their finance functions and processes. One of our partners, Adaptive Insights, recently surveyed 160 CFOs across the globe for its most recent CFO Indicator Report, Full Steam…
October 19, 2018
A Successful Summer of Internships at Revelwood
This summer, Revelwood kicked off a new internship program. While we’ve had interns in the past, this year we kicked off a new intern program modeled after that of one of our vendor-partners in a different industry. The Lead Development Rep (LDR)…
October 17, 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…
September 25, 2018
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Bookmarks in Planning Analytics Workspace
Did you know that you can bookmark items for quick navigation in IBM Planning Analytics Workspace (PAW)? PAW’s navigation menu allows you to scroll through your entire system which includes cubes, dimensions, views and other aspects of your model. This ability to…
September 18, 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…