IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using Words Instead of Numbers
In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how you can use words to input data in Planning Analytics Workspace (PAW) instead of numbers. In the old TM1-world, you had the ability to put…
March 3, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Admin Alerts
In your existing TM1 world, much of the administration is done via your computer’s operating system. Planning Analytics brings much of the administration into your environment via a web-based interface. One of the tasks you can do in this interface is to…
February 25, 2020
IBM Planning Analytics Tips & Tricks
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 2.0.44, that enables you to reorder TM1 cubes. Your TM1 cubes were likely designed for a specific…
February 18, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: Filtering in Planning Analytics
In today’s IBM Planning Analytics Tips & Tricks video, our FP&A Technology Director, Lee Lazarow, demonstrates how to do filtering in Planning Analytics. Filtering in Planning Analytics Workspace (PAW) will make it easy for your users to select the data they want…
February 11, 2020
IBM Planning Analytics Tips & Tricks
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 ranges and/or strings. CONCAT will eventually replace CONCATENATE, but Microsoft has not released plans…
February 4, 2020
IBM Planning Analytics Tips & Tricks
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 chores that are associated with a specific process. Once you have mastered the techniques Lee explains…
January 28, 2020
IBM Planning Analytics Tips & Tricks
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 the first TRUE condition. The main objective of IFS…
January 21, 2020
IBM Planning Analytics Tips & Tricks
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 create buttons for your TI scripts, you simplify tasks for your end users and create a…
January 14, 2020
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…