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…
April 18, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel YEARFRAC
I often build models that define the fraction of a year for a given month. For example, January is approx. 8.5% of a calendar year (31/365) and September is approx. 11.5% of a working day’s calendar (30/260). But what happens in situations…
March 14, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel EOMONTH
Thirty days has September … Do you sing that out loud every time you want to determine the number of days in a month? If so, do you have to pause and think about the end when defining the last day of…
February 21, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTSPLIT
Have you ever needed to parse a text string into different columns in Excel? This is easy to do via the text-to-columns wizard, but what if you wanted to do this via a formula? The TEXTSPLIT function allows you to split a…
February 7, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel TEXTBEFORE & TEXTAFTER
A while back, I wrote a blog about using Excel to manipulate text. The functions in that blog allow you to rip text apart and put the pieces together so you can parse out pieces of your text strings. Since that writing,…
December 13, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel SEQUENCE
Have you ever needed to quickly generate a list of numbers? Maybe you need to create a list from 1-100. Maybe you want to create a list of the first 100 even numbers. Maybe you want to create those same lists in…