Welcome to Revelwood’s Knowledge Center
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx Writeback Mode
As of version 2.0.68 of IBM Planning Analytics for Excel (PAx), a new toggle was added to the IBM Planning Analytics ribbon that allows users to decide how DBRW formulas are treated when data is entered. Prior to version 2.0.68, this option was…
November 9, 2021
Financial Close & Consolidation
Modern Accounting: 4 Best Practices for your Month-End Close
This is a guest blog post from our partner BlackLine, explaining how to build a best practices checklist for your month-end close. A month-end close checklist is critical to ensuring a smooth and successful close process. Its purpose is to provide visibility into…
November 4, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using IF With a Counter
I recently worked with an IBM Planning Analytics client to optimize a model that uses a check value to determine when to do further calculations. The check typically resulted in either a one or a zero and a series of rules were written…
November 2, 2021
FP&A Done Right: Is Your Data Trapped in a Legacy ERP System?
This is a guest blog post from our partner Workday Adaptive Planning, highlighting the challenges Finance leaders have with legacy ERP systems. In late 2019, Mercer surveyed business leaders about their expectations for the next three years. Nearly three out of four…
October 29, 2021
The Office of Finance Should Make the Most of a “Use it or Lose it” Budget Policy
Does your company have a “use it or lose it” budget policy for this year or a situation where next year’s budget shrinks if you don’t spend all of this year’s budget? Losing budget this year is just as bad as having…
October 28, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1Ellist
Have you ever wanted to use Excel to create a list of elements within an IBM Planning Analytics dimension? If so, the TM1ELLIST function is your answer! This function is used to return a list of elements with parameters to define the look of…
October 26, 2021
Financial Close & Consolidation
Modern Accounting: The Key Role of Today’s CAO
This is a guest blog post from our partner BlackLine, on the challenges and opportunities facing today’s Chief Accounting Officers. The office of the CAO has become a busy place. Chief Accounting Officers, whose normal responsibilities include overseeing the financial close and internal…
October 21, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Stacked Columns Dimension Order
Column charts are one of the most common types of data visualizations and stacked columns are simply an expansion of the columns. The stacking allows you to compare two sets of data within the same chart. But have you ever thought about how…
October 19, 2021
FP&A Done Right: Modernizing the Reporting Process
This is a guest blog post from our partner Workday Adaptive Planning, explaining how finance leaders should think about reporting. Imagine standing in the middle of a large, noisy crowd. You can hear the sound of many voices. But rather than follow…