IBM Planning Analytics Tips & Tricks

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAx Control Objects
IBM Planning Analytics uses cubes to store metadata information such as security and attribute information. These automatically generated cubes are called control cubes (which I sometimes call “squiggle cubes”) and begin with a prefix of a right curly brace. Server Explorer used…
November 12, 2019

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Learn How to Use the Pivoting and Selecting Shortcut
Our latest IBM Planning Analytics Tips & Tricks tutorial video explains how and why you should use the pivoting and selecting shortcut. In this short video, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to pivot in exploration and select an element…
November 5, 2019

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New Excel Feature – XLOOKUP
Did you know Excel has a new feature called XLOOKUP? For those of you who read these blogs regularly, you know that much of the focus is placed on IBM Planning Analytics Tips & Tricks. However, I periodically also like to pass…
October 29, 2019

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Learn how to use Snap Commands in IBM Planning Analytics
IBM Planning Analytics has a feature, snap commands, that simplifies various routine tasks. In our latest IBM Planning Analytics Tips & Tricks video, Revelwood’s FP&A Technical Director, Lee Lazarow demonstrates how snap commands in Planning Analytics allow you to change computer jargon…
October 22, 2019

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The New Set Editor
IBM Planning Analytics contains a new set editor that makes it easy to manipulate the elements in a subset. This approach allows you to quickly add a single element, add a group of elements, or replace an existing set of elements. Once…
October 15, 2019

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: Bookmarks in IBM Planning Analytics Workspace
In our latest IBM Planning Analytics Tips & Tricks video, Revelwood’s FP&A Technical Director, Lee Lazarow explains and demonstrates how bookmarks work in IBM Planning Analytics Workspace (PAW). Bookmarks in PAW are quick and easy to use and make a big difference…
October 8, 2019

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Cell Level Security Defaults
Did you know that you can have TM1 / Planning Analytics security always use your cell security definitions … even when the security definition cell is blank? Values in a cell security cube override all other security. But if an intersection in…
October 1, 2019

IBM Planning Analytics Tips & Tricks
New Video Series: IBM Planning Analytics Tips & Tricks
Every Tuesday we publish written blog posts sharing IBM Planning Analytics Tips & Tricks from our PSG team. Today, we’re adding to our tips & tricks with a series of videos! Watch this short video from FP&A Technology Director, Lee Lazarow, to…
September 24, 2019

IBM Planning Analytics Tips & Tricks
New Video Demo – Creating Dashboards in IBM Planning Analytics
In the third video of our series Creating a Cube in IBM Planning Analytics, Revelwood’s FP&A Technology Director, Lee Lazarow, demonstrates how to create a dashboard in IBM Planning Analytics. Watch this short video demo to learn how to create a dashboard…