IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Regions within Regions
A while back I wrote a blog post about using Regions within Planning Analytics rules. Regions allow you to make your rules easier to navigate and read when scrolling through many lines of code. But did you know that you can have…
January 7, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Rule Timestamps
TM1’s print report wizard still exists in Perspectives and many clients continue to use this approach. I recently came across an issue where a client wanted to “burst” a report and include a time stamp on a report that is being snapshot…
December 10, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula
Excel is, and always will be, a powerful tool for the financial team. With so much power, there are many great Excel formulas that rarely get used. I recently had a situation where I wanted to easily replicate a sheet and have…
December 3, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Trimming Picklists
Did you know that IBM Planning Analytics includes a feature that helps trim the list of choices in a picklist as you type? There are many different ways to create picklists in TM1/Planning Analytics and Revelwood has previously written about creating picklist…
November 26, 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: 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: 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: 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
IBM Planning Analytics Tips & Tricks: Blank Rows in Active Form Reports
Did you know when creating active form reports, you may sometimes want to separate sections? Some people like to create this separation via dashes or via bold line formatting. Some prefer to create “dummy” elements and use conditional formatting to make them…