Welcome to Revelwood’s Knowledge Center

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Shortcuts in PAW Models
Did you know there are shortcuts you can use in IBM Planning Analytics Workspace (PAW) when creating new models? In legacy tools such as Architect, required that you create your dimensions, cubes, processes and chores one piece at a time. IBM Planning…
August 16, 2022

FP&A Done Right: Finance’s Role in ESG Reporting
ESG (environmental, social, governance) reporting is a growing market. According to McKinsey, “ESG issues represent critical challenges for both boards and executive teams.” One question companies are facing is “who is responsible for ESG reporting?” Some companies have – or will have…
August 12, 2022

Financial Close & Consolidation
Modern Accounting: Why Does Intercompany Accounting Crash Your Close?
This is a guest blog post from our partner BlackLine, explaining why intercompany accounting is killing your close. It’s a fact of life that if you can’t reconcile your intercompany accounts, you can’t close your books. The goal of intercompany accounting is netting to…
August 11, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Customizing Background Colors for Data and Header Cells
Did you know that update 76 of IBM Planning Analytics allows you to customize background colors for data and header cells within your Planning Analytics Workspace (PAW) views? To customize these colors, click on a view within a page in PAW and…
August 9, 2022

Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Utilizing Split Rows in Modeled Sheets
Do you know how to utilize splits in Workday Adaptive Planning for a modeled sheet? Splits allow you to have multiple lines as part of one record and you can set splits on a column-by-column basis. A use case might be a…
August 3, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Adding and Editing Connection URLs in Planning Analytics for Excel
Do you know how to add a new Connection URL or Edit an existing Connection URL in Planning Analytics for Excel? Here are the steps to follow: Adding a Connection URL Once Planning Analytics for Excel has been launched, go into the…
August 2, 2022

Financial Close & Consolidation
Modern Accounting: Four Key Ways AR Automations Propel Financial Operations
This is a guest blog post from our partner BlackLine, explaining four ways AR automation moves financial operations forward. Due to challenges in recent years, there’s been a shift in the way companies approach people retention—with varying outcomes. Many organizations now offer…
July 28, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel DELET Function
A while back I wrote a blog about the SCAN function which showed how you can search for specific characters and then combine this with the SUBST formula to create new sets of text. But what if you wanted an easier way…
July 26, 2022

Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Data Integration and the Excel Spreadsheet Data Source
Did you know that Workday Adaptive Planning can use Microsoft Excel Workbooks as Data Sources for Data Integration? It’s true! The process is surprisingly simple if a few basic rules and steps are followed: Your column names, positions, and formatting should remain…