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 … [Read more...] about IBM Planning Analytics Tips & Tricks: PAx Control Objects
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Trimming Picklists
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Learn the Excel CELL Formula
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Regions within Regions
IBM Planning Analytics Tips & Tricks: Creating Buttons for TurboIntegrator Scripts
In today’s IBM Planning Analytics video tutorial, our FP&A Technical Director, Lee Lazarow, shows you how to easily create buttons for TurboIntegrator (TI) scripts. When you … [Read more...] about IBM Planning Analytics Tips & Tricks: Creating Buttons for TurboIntegrator Scripts
IBM Planning Analytics Tips & Tricks: Excel’s IFS Function
While the IF function has been around for a while now, IFS is new to Excel. This function checks whether one or more conditions are met and then returns the value associated with … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel’s IFS Function
IBM Planning Analytics Tips & Tricks: Reviewing Chores
In today’s IBM Planning Analytics video tutorial, our FP&A Technology Director, Lee Larazow, demonstrates PAW v 2.0.43’s new approach that allows you to easily review the … [Read more...] about IBM Planning Analytics Tips & Tricks: Reviewing Chores
IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions
Microsoft Excel has recently introduced a new version of the CONCATENATE function called CONCAT. The purpose is similar in that the new function still combines text from multiple … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel’s CONCAT and TEXTJOIN Functions
IBM Planning Analytics Tips & Tricks: How to Reorder TM1 Cubes in Planning Analytics Workspace
In today’s IBM Planning Analytics Tips & Tricks video, our PF&A Technology Director, Lee Lazarow, demonstrates a new feature in Planning Analytics Workspace (PAW) version … [Read more...] about IBM Planning Analytics Tips & Tricks: How to Reorder TM1 Cubes in Planning Analytics Workspace