Welcome to Revelwood’s Knowledge Center
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Show Totals
One of IBM Planning Analytics’ purposes is to serve as an aggregation tool. As a result, many of your explorations consist of a series of base level elements plus a total. Here is an example of a simple exploration that shows details…
July 19, 2022
Financial Close & Consolidation
Modern Accounting: 6 Essential Qualities for Surviving the Robot Uprising in Accounting
This is a guest blog post from our partner BlackLine, explaining how you could be more productive with fewer resources, less overtime, and also easily improve the quality of your work. As accounting and finance professionals, you do so much more than…
July 14, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel MAXIFS and MINIFS
Many of you know that Excel’s MAX function will define the largest value within a range. And many of you also know that Excel’s SUMIFS function will allow you to merge IF checks into your sum formulas. But did you know that…
July 12, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Loan Amortization
Loan amortization schedules in Workday Adaptive Planning are slightly different than those done in Excel. In Excel the typical amortization schedule looks like this: In Workday Adaptive Planning most versions only go 1-5 years into the future. Creating a complete 10-25 year…
July 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Escape Character
Have you ever been in a situation where you have an element name with an apostrophe (or two) in IBM Planning Analytics? Examples of this might entail last names such as “O’Connor” or “O’Sullivan”? Although IBM best practices specify that the apostrophe…
July 5, 2022
Financial Close & Consolidation
Modern Accounting: How to Approach Intercompany Recharging
This is a guest blog post from our partner BlackLine, explaining best practice recommendations for managing expenses across various business centers within your company. What Is Intercompany Recharging? What exactly is a recharge in the world of accounting? It essentially involves providing…
June 30, 2022
Fluence Technologies Earns “Outstanding” Overall BPM Pulse Rating from BPM Partners
Revelwood’s partner, Fluence Technologies, earned a 4.82 overall BPM Pulse Rating from BPM Partners. Vendors that receive a customer satisfaction rating of 4.75 – 5.00 are considered “outstanding.” Fluence’s customer satisfaction ratings are above industry average and include the following aspects: Financial…
June 29, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based on a Cube
Did you know you can use MDX to create dynamic subsets based on cube values in IBM Planning Analytics? In our example we will only show companies with net sales greater than 30,000,000 in the selected year. An MDX statement that can…
June 28, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Choose the Correct TIME Syntax
Are you familiar with all the TIME syntax in Workday Adaptive Planning? Do you know what is the best practice for each of them? This blog post will tell you the difference between them. Below are the most common TIME syntax in…