IBM Planning Analytics Tips & Tricks
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:…
October 12, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Color Schemes in a Waterfall Chart
Did you know IBM Planning Analytics Workspace (PAW) allows you to change the color scheme in your waterfall charts? The goal of a waterfall chart is to show how an initial value is affected by the intermediate values – either positives or…
October 5, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Mekko Chart
IBM Planning Analytics Workspace (PAW) offers many visualization options to allow you to show and analyze your data in creative ways. This includes standard chart types such as bar, line and pie. But it also includes some reports that are not always understood. One of…
September 21, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Defining a Process Within Existing Chores
There are times when you need to change a process within an existing chore in IBM Planning Analytics. The challenge is to understand what chores will be impacted by a change in a process. You could edit or remove and process and…
September 14, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Explorations – Row & Column Headers
Visualizations are used to provide an easy understanding of large data sets. After all, a picture is worth a thousand words. However, what happens when you want to see the intricate details of your numbers? This is where IBM Planning Analytics Workspace (PAW) explorations come…