Welcome to Revelwood’s Knowledge Center
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function
Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…
June 21, 2022
FP&A Done Right: The Changing Role of the CFO
This is a guest blog post from our partner Workday Adaptive Planning, explaining strategy and vision for the Office of Finance. Companies are asking more of their CFOs than ever before. They’re expected to lead environmental, social, and governance (ESG) initiatives, oversee…
June 17, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors
One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…
June 14, 2022
Financial Close & Consolidation
Modern Accounting: Using AR Automation to Boost Cash Flow
This is a guest blog post from our partner BlackLine, explaining how to gain cash flow confidence with AR automation. Table of contentsDisruptions, Borrowing & Inefficient ProcessesRaise the Bar With AR Automation Put simply, a significant reason businesses are struggling right now…
June 9, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Revenue Cohort Modeling
Do you know about cohort modeling in Workday Adaptive Planning? A cohort model provides meaningful insight of data grouped into subsets based on any characteristic important to the company. The groups are called “cohorts.” Cohorts can be based on time (i.e. season,…
June 8, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: NumberToStringEx
IBM Planning Analytics has the ability to export data to flat files with the use of the ASCIIOUTPUT and TEXTOUTPUT functions. However, these two functions will only accept string variables. That means that numeric data will first need to be converted to…
June 7, 2022
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Check Boxes in Modeled Sheets
As part of the 2022R1 release, Workday Adaptive Planning has enabled some new enhancements for Modeled Sheets. I am most excited for the checkbox capability, a new feature for Modeled Sheets. In addition to being a nice visual icon for users in…
June 1, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: WildcardFileSearch
Depending on your business process, you may need to load similar data from multiple files. One such example is loading headcount from different HR systems. This may be necessary if your company has gone through a merger. Another example is if you have forecast data…
May 31, 2022
FP&A Done Right: Financial Forecasting Processes that Guide Business Strategy
This is a guest blog post from our partner Workday Adaptive Planning, outlining nine ways to plan in the changing world of finance. Table of contentsStep 1: Define Your TermsStep 2: Model Your RevenueStep 3: Model Your ExpensesStep 4: Set Your CadenceStep…