IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel DATE Function Updated
Some of you may remember an Excel feature that I posted about last year which explained how the DATE function will convert invalid dates into real ones. For example, DATE(2020,7,35) will be converted to August 4, 2020 since there are not 35 days…
August 17, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Lines vs Area for Multiple Elements
A line chart is typically used to show values over time. This type of chart is great to see trends with your data. An area chart is also used to show values over time and is sometimes referenced as a line chart…
August 10, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Code Char
Have you ever written a TurboIntegrator script and wanted to check the first character of a value to see if it was a number or a letter? Have you ever needed to insert a single or double quote into a string without “breaking”…
August 3, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Depreciation
P&L planning models consist of a variety of inputs, including revenue planning and various forms of expense planning. In addition to these standards, we are often asked to develop other planning components. One of these components entails a depreciation process, which leads to…
July 27, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Scatter Chart vs Bubble Chart
A scatter chart is used to show relationships within your data. This type of chart is great to see patterns and groupings over a large set of values. A bubble chart is also used to show relationships and it also great to see patterns. So…
July 20, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Marker Shape
A line chart can either be a simple line or it can include markers for each data point. Most people associate a marker as a simple dot, but did you know that IBM Planning Analytics Workspace (PAW) allows you to configure the shape…
July 13, 2021
Technical Bulletin: End of Support for IBM Planning Analytics Local, IBM Planning Analytics Advanced and IBM Planning Analytics Express Versions 2.0.0 – 2.0.8
IBM recently announced End of Support (EOS) dates for older versions of IBM Planning Analytics Local, IBM Planning Analytics Advanced and IBM Planning Analytics Express. Here are the important dates to know: April 30, 2022 – End of support for versions 2.0.0…
July 6, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: 445
Time is an important aspect when implementing planning models. Calculations often use time to spread an annual amount throughout the year. However, the definition of “spread” does not always entail a simple approach. Sometimes clients want to spread an annual value evenly through the…
July 6, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Padding
Did you know that IBM Planning Analytics Workspace (PAW) offers a feature calling “padding” which defines lines are separated within a chart? The concept of padding is the equivalent of defining white space in between the lines (e.g., no padding) or making…