IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Setting up the Forecast
This is part three in a three-part series on IBM Planning Analytics' new feature, Forecasting. In our previous blog about IBM Planning Analytics' new Forecasting feature, we reviewed the steps required to preview your forecast. Once previewed, you can then run your…
March 9, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Previewing the Forecast
This is part two of a three-part series on IBM Planning Analytics new Forecasting feature. In our first blog about Planning Analytics' new Forecasting feature, we reviewed the steps required to configure your forecast. Once configured, you can then preview your forecast…
March 2, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Configuring the Forecast Settings
This is part one of a three-part series on IBM Planning Analytics new Forecasting feature. The new IBM Planning Analytics Forecasting feature allows you to quickly populate future time periods based on past data values. This feature is especially useful to prepopulate…
February 23, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Forecasting – Configuring the Time Dimension
The new IBM Planning Analytics Forecasting feature allows you to quickly populate future time periods based on past data values. This feature is especially useful to prepopulate a data set for you or your team to then adjust as you see fit.…
February 16, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Dimension Attribute Types
Did you know that IBM Planning Analytics dimensions can have defined types and that these defined types are necessary for certain Planning Analytics features to operate correctly? For example, the new predictive forecasting functionality within Planning Analytics Workspace (PAW) requires the use…
February 9, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Manipulating Text in Excel
Have you ever wanted to manipulate text within Excel? Excel has a series of functions that allow you to parse text strings based on whether you want to reference the left, the right, or the middle of the cell contents. For example,…
February 2, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s NETWORKDAYS Function
Have you ever wanted to define the number of working days between two calendar dates? Do you define “working days” simply as non-weekend days or do you also include holidays? Did you know that you can calculate this information using Excel’s NETWORKDAYS…
January 26, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Waterfall Chart
IBM Planning Analytics Workspace (PAW) includes various visualizations that can be used to view your data. One of these visualizations entails a chart called a waterfall chart. This type of chart will help you show the components of a summarized number and…
January 19, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TYPE Function
Have you ever referenced a list in Excel and needed to know whether each value was a number or a string? This may be required when another function depends on the type of value in each cell. Excel has a function called…