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
Alternatives to Traditional Budgeting
Now that we have spent some time discussing several problems with traditional budgeting, let’s look at some alternate approaches. Here is a review of the first three problems from my prior blog: Time Consuming and Costly Quickly Irrelevant and Outdated Financial Process…
September 20, 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…
September 18, 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…
September 17, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Cellput vs CellIncrement
Did you know one of the most popular uses of TurboIntegrator is to load data into a cube? There are many different commands that can be used to load data depending on whether the data consists of numbers, strings or attributes. When…
August 27, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Errors in Non-writeable Cells
Did you know IBM Planning Analytics is smart enough to look at the write permissions of a cell before attempting to load values into a cube? Have you ever tried to run a load process and then receive errors stating that you…
August 20, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Clearing All Data from a Cube
Did you know there may be several situations during development where you may want to clear all of the data from a specific cube? This could be due to a new process to reload data, a second round of user testing, or…
August 13, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Financial Rules
Did you know one of the great things about Excel is that there are many built-in functions that calculate values associated with specific industries? One of these industries is the financial industry where Excel is sometimes used to calculate values associated with…
August 6, 2019
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: IFERROR
Did you know one of the great things about creating TM1 Web sheets is that you simply need to create an Excel sheet and then press a button called Publish? This will convert your Planning Analytics formulas into a web-based interface that…