IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Simplifying Dimension Maintenance
Watch our latest IBM Planning Analytics Tips & Tricks video to learn how to simplify dimension maintenance in Planning Analytics. Once you master these easy techniques, you’ll be able to do all of your dimension maintenance from the Planning Analytics Workspace (PAW)…
November 19, 2019
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
Revelwood Launches Report Conversion Service for Migrating Excel & TM1 Web Reports to PAx
Revelwood has launched a new Report Conversion service to help TM1 users to migrate their Excel and TM1 Web (Websheets) reports to Planning Analytics for Excel (PAx). Our service also helps TM1 users recreate their existing Excel or TM1 Web reports in…
October 17, 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
Understanding PVUs
“A Processor Value Unit (PVU) is a unit of measure used to differentiate licensing of software on distributed processor technologies (defined by Processor Vendor, Brand, Type and Model Number). IBM continues to define a processor, for purposes of PVU-based licensing, to be…
October 3, 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…