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: Feeding Using Cube Values
Feeders are one of the best ways to maximize the performance of rules. Essentially, feeders define where to perform calculations to better handle sparsity in a cube. There are many ways to reference feeder elements. One of these ways is by using…
May 11, 2021
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: Convert Existing View Directly to Reports
Did you know that Planning Analytics for Excel (PAx) provides the ability to convert an existing view directly to a report in Excel? Without opening the view as an Exploration, you can start building your report directly from the Task Pane. Just…
November 24, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx Task Pane Workbook Tab
Did you know that Planning Analytics for Excel (PAx) automatically keeps track of the Planning Analytics objects you have open in an Excel workbook? Simply click on the Workbook tab of your Task Pane to view the list of Dynamic reports, Action…
November 17, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions
Microsoft Excel has recently introduced a new version of the CONCATENATE function called CONCAT. The purpose is similar in that the new function still combines text from multiple ranges and/or strings. CONCAT will eventually replace CONCATENATE, but Microsoft has not released plans…