Welcome to Revelwood’s Knowledge Center
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: DefineCalc
IBM Planning Analytics for Excel (PAx) version 80 introduced a new function called “DefineCalc." This function allows a user to create a custom calculation using TM1/Planning Analytics data via the use of MDX. There are a series of parameters, and the key…
January 3, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Top 3 Blog Posts of 2022
What was your favorite IBM Planning Analytics Tips & Tricks blog post in 2022? We did some analysis and determined the three most popular PA Tips & Tricks blog posts. They are: 1. IBM Planning Analytics Tips & Tricks: Dynamic Subsets Based…
December 27, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: 2022’s Top 3 Tips & Tricks Videos
The Revelwood team has created many IBM Planning Analytics Tips & Tricks videos. Which ones made it into the top 3 with the most views on YouTube? [Drumroll please!] They are (in order of the most views): 1. Shortcuts in PAW Models…
December 20, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER
A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing,…
December 13, 2022
Financial Close & Consolidation
Modern Accounting: Adjusting Journal Entries
This is a guest post from David Brightman at our partner BlackLine, explaining why it’s necessary to adjust journal entries. What Are Adjusting Journal Entries? Adjusting journal entries are used to adjust a company’s financial statements and bring them into compliance with…
December 8, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Set Up Action Buttons in Planning Analytics for Excel
Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up action buttons in IBM Planning Analytics for Excel (Pax). In this video, Dillon shows your three approaches: …
December 6, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Set Up Synchronizations in IBM Planning Analytics Workspace
Revelwood’s latest IBM Planning Analytics Tips & Tricks video features Dillon Rossman, a consultant with our IBM Planning Analytics practice, demonstrating how to set up synchronizations in Planning Analytics Workspace (PAW). In this video, Dillon walks you through how to: Change an…
November 29, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel SEQUENCE
Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in…
November 22, 2022
FP&A Done Right: ESG – An Imperative for Growth
As part of our series on ESG reporting, we are featuring guest blog posts from our partners. This post from Workday Adaptive Planning highlights thoughts from finance leaders on ESG and more. How can companies “walk the talk” to create value for…