
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 & Tricks: WildcardFileSearch
Depending on your business process, you may need to load similar data from multiple files. One such example is loading headcount from different HR systems. This may be necessary if your company has gone through a merger. Another example is if you have forecast data…
May 31, 2022

Facing an IBM Planning Analytics / TM1 Talent Shortage?
There’s plenty of news about “The Great Resignation” or the talent shortage/war. In some cases, the challenge is not in finding someone, but in finding the right skills. This is particularly true for companies searching for people with IBM Planning Analytics /…
May 25, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace Visualization Axis
Did you know you are able to create custom axis labels for IBM Planning Analytics Workspace (PAW) visualizations? Below is a column visualization that shows periods on the x-axis and a net income amount on the y-axis. As you can see, a generic…
May 24, 2022

Introducing DataMaestro, the Data Orchestration Platform for IBM Planning Analytics / TM1
We’ve just released a new product designed to make the lives of IBM Planning Analytics / TM1 systems administrators’ easier. DataMaestro is a solution for managing and moving data that saves Planning Analytics / TM1 users significant time and money by making…
May 23, 2022

Optimize your Business Processes for Planning, Reporting and Analysis
When was the last time you examined – and optimized – your planning processes? Have you made adjustments over the last few years to accommodate changing office habits, work from home environments and mergers and acquisitions? If your business is like most,…
May 20, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Refresh PAW Visualizations Automatically
Did you know that you can have IBM Planning Analytics Workspace (PAW) visualizations refresh automatically? To enable this setting, first make sure you are in “Edit” mode within your PAW book. You can then click on your visualization then click “Properties” in the…