IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Alternative Row Formats for Excel Reports
In the early days of computing, printers often used paper that had alternating white and green areas which allowed the reader to easily follow a line of text across the page. This was known as “green bar” paper. While we no longer…
November 10, 2020
Workday Adaptive Planning Tips & Tricks
Workday Adaptive Planning Tips & Tricks: Override Formulas in Sheets
If you want to write a formula in an account in Workday Adaptive Planning, but still want to give your team the ability to override the formula and enter different data, you can use Shared Formulas to achieve that. The Shared Formulas…
November 4, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Minimizing the Subset Area
Are your member names long and hard to see in the subset editor in IBM Planning Analytics? Does it get confusing to see both the available members and the current set at the same time? Both situations can be solved by hiding…
November 3, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Show Members
Did you know that while you are doing dimension maintenance, you can quickly view an element’s parents or children in IBM Planning Analytics Workspace (PAW) via a single click? Here's how you can do this: Step 1: Select the dimension to be…
October 27, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: An Approach to Strengthening your MDX Skills
Are you new to IBM Planning Analytics and looking for a good way to learn about the various commands associated with MDX? The Planning Analytics subset editor offers a great way to teach you about MDX expressions that can be used to…
October 20, 2020
IBM Planning Analytics Workspace (PAW) Version 2.0.57 Release
IBM recently released Version 2.0.57 of Planning Analytics Workspace (PAW). Version 2.0.57 is currently offered as a local-only release and will soon be available on the cloud (as version 2.0.58). This update contains many significant changes, including both new functionality and a…
October 16, 2020
FP&A Done Right: To Recover from Economic Shock, Are CFOs Envisioning Enough Scenarios?
This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. Hansen explains the why scenario modeling is imperative when facing disruption. Three out of four finance executives recently acknowledged that the planning processes their companies have in…
October 16, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: The Aggregate Function
Watch our latest IBM Planning Analytics Tips & Tricks video to learn about the aggregate function. Lee Lazarow, Revelwood’s FP&A Technology director, demonstrates this new function that allows you to summarize values that cannot be added up or averaged. You’ll see Lee…
October 13, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Sort Elements within a Subset
Did you know that there are two different ways to sort elements within a subset in IBM Planning Analytics? Below is an example of a subset which shows a standard time dimension: One approach sorts all elements either ascending or descending, regardless…