IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s Camera Tool
The Linked Picture tool (aka Camera tool) is a little-known feature in Excel that you can use to give your dashboards and reports greater flexibility. In summary, the linked image is an image that is connected to the source data and updates…
July 11, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Headcount Analysis
Did you miss our recent webinar on headcount analysis? Here’s a high-level recap of what we covered. In short, IBM Planning Analytics is a powerful, flexible tool for headcount analysis. Headcount analysis is a critical component of any organization's workforce planning and…
June 27, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Waterfall Charts
Did you miss our webinar on waterfall charts in IBM Planning Analytics? Here’s our take on best practices and how and why to use waterfall charts. Waterfall charts, also known as bridge charts, floating column charts, or cascade charts, are a data…
June 20, 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: HTTPPORTNUMBER
Did you know that when you create a new TM1 / IBM Planning Analytics instance that the HTTPPORTNUMBER parameter is required? This setting is placed within the TM1S.cfg file for your model. Some things to note when defining the HTTPPORTNUMBER parameter: 1.…
June 6, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Popular Posts, Part 2
Earlier this month we shared three of our most popular IBM Planning Analytics Tips & Tricks blog posts. Since we publish these tips & tricks posts every Tuesday, we have plenty of tips you might have missed. Here are three more of…
May 30, 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: Popular Posts, Part 1
Revelwood’s IBM Planning Analytics team covers a wide range of topics in their weekly IBM Planning Analytics Tips & Tricks posts. We’ve decided to share some of the most popular posts over the past 12 months. IBM Planning Analytics Tips & Tricks:…
May 16, 2023
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Run TI Processes from PAx Task Pane
Did you know that you can run TurboIntegrator (TI) processes via the task pane in Planning Analytics for Excel (Pax)? Within the task pane, you can choose to display processes by clicking on the “Show and Hide” button and selecting the option…