
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel CubeDimensionCountGet Function
Have you ever written a TurboIntegrator process and needed to know how many dimensions are in a specific cube? Maybe you want to loop through each dimension to create a zero out view. You can do this by using the TABDIM function…
June 21, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors
One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…
June 14, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: NumberToStringEx
IBM Planning Analytics has the ability to export data to flat files with the use of the ASCIIOUTPUT and TEXTOUTPUT functions. However, these two functions will only accept string variables. That means that numeric data will first need to be converted to…
June 7, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips and Tricks: Adding a user in Planning Analytics Workspace
Do you know how to add a user in IBM Planning Analytics Workspace (PAW)? The steps are detailed below. As an Administrator, navigate to the Administration Users and Groups page. You can get there from the home page as follows: Click the…
February 1, 2022

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: PAW Gridlines
Have you ever created a PowerPoint slide by using gridlines to position your pieces and wished that you can do the same in IBM Planning Analytics (PAW)? Now you can! PAW version 57 introduced many settings that allow you to further customize…
April 20, 2021

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: MS Word AutoCorrect
Part of implementing IBM Planning Analytics is ensuring that users understand their model. This often entails documentation that is created as a Microsoft Word document. Most of us know how to use Word but get frustrated typing some of the complex OLAP…
March 30, 2021

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Administration Page Layout
Did you know that the administration page layout has changed in IBM Planning Analytics Workspace (PAW) update 57? In previous versions of PAW, the administration page used a tabbed approach that separated each component into its own tab. This required administrators to…
March 23, 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…