IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW “Spacers”
Have you ever created an exploration in IBM Planning Analytics Workspace (PAW) that contains a lot of data and wish that you could separate the information? PAW allows you to insert blank rows and columns called “spacers” into your exploration. Here is…
March 19, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s ROUND Function
Most standard financial reports round to some form of a large value. For example, the report may show numbers in millions or rounded to the nearest 100,000. This is done in Excel via the ROUND function. The function has two parameters: =ROUND(number,…
March 5, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Generated Statements
One of the great things about IBM Planning Analytics Perspective’s process editor is that the wizard can be used to create code within your scripts. The results of the wizard based statements are inserted within areas called “Generated Statements.” However, there may…
February 6, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Pie Chart Total
Pie charts are a type of visualization known as composition. Composition charts are designed to show the parts of a whole. This is a great way to look at the pieces of total. For example, the branches in a region or the…
January 23, 2024
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Region Expansion
A while back I wrote a blog about regions within regions in IBM Planning Analytics. This approach allows you to make your rules easier to navigate and read when scrolling through many lines of code. As you create regions, you can expand…
November 28, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAW) Process Error Logs
Do you know how to use IBM Planning Analytics Workspace (PAW) to access error logs from your TurboIntegrator (TI) processes? It’s as simple as a single click! To access your logs, right-click on the Processes node in the workbench and select the…
September 26, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAx) Zoom Bar
One of the strengths of OLAP tools like IBM Planning Analytics is that you can create data sets that stack multiple dimensions together. Planning Analytics Workspace (PAW) allows you to easily convert those data sets into an easy-to-read visualization. Here is an…
June 13, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Set Editor Remove Duplicates
In a recent blog post, we explained how to use Excel to produce a list of unique values. But what if you wanted to do the same thing in your subset? IBM Planning Analytics Workspace (PAW) version 82 introduced an approach into…
May 23, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Users and Groups
Do you know how to manage your users and groups in IBM Planning Analytics Workspace (PAW)? As of version 84, PAW now allows you to edit this information via a single click. To open the users and groups editor, right-click on a…