IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
Questions on Virtual Hierarchies in IBM Planning Analytics
Virtual hierarchies in IBM Planning Analytics are not as well understood as you might suspect. We’ve found that many Planning Analytics users don’t understand what virtual hierarchies are, how to use them, and when to use them. We’re here to answer your…
November 30, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Displaying Percentages on a Planning Analytics Workspace (PAW) Pie Chart
In a recent blog post we discussed pie charts and how you can show data points or percentages in an IBM Planning Analytics Workspace (PAW) pie chart. We also have an IBM Planning Analytics Tips & Tricks video that shows how easy it is…
November 23, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Pie Percent or Value?
Pie charts are one of the most common types of data visualizations. A pie chart is defined as a component report, which means that it is design to show part-to whole relationships. This approach makes it easy to get a general sense of…
November 16, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx Writeback Mode
As of version 2.0.68 of IBM Planning Analytics for Excel (PAx), a new toggle was added to the IBM Planning Analytics ribbon that allows users to decide how DBRW formulas are treated when data is entered. Prior to version 2.0.68, this option was…
November 9, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using IF With a Counter
I recently worked with an IBM Planning Analytics client to optimize a model that uses a check value to determine when to do further calculations. The check typically resulted in either a one or a zero and a series of rules were written…
November 2, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1Ellist
Have you ever wanted to use Excel to create a list of elements within an IBM Planning Analytics dimension? If so, the TM1ELLIST function is your answer! This function is used to return a list of elements with parameters to define the look of…
October 26, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Stacked Columns Dimension Order
Column charts are one of the most common types of data visualizations and stacked columns are simply an expansion of the columns. The stacking allows you to compare two sets of data within the same chart. But have you ever thought about how…
October 19, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Approaches to Allocations in Planning Analytics
Many Revelwood clients have allocations models within their IBM Planning Analytics environment. Some – like those we highlighted in a recent webinar – have complex and/or unique approaches to their allocation models. During the webinar we received several questions. Here are a few of them. Q:…
October 12, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Approaches to Allocations in Planning Analytics
Many Revelwood clients have allocations models within their IBM Planning Analytics environment. Some – like those we highlighted in a recent webinar – have complex and/or unique approaches to their allocation models. During the webinar we received several questions. Here are a few of them. Q:…