
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Excel DATE Function
Many of you already know about Excel’s DATE function. The function is used to create a date by defining specific values for the year, month and day. DATE(2020,7,20) gives a result of 7/20/2020. And some of you know that you can also…
June 9, 2020

FP&A Done Right: What Must FP&A Do Differently to Make Planning a Success
This is a guest blog post from our partner Adaptive Insights, written by Anders Liu-Lindberg. Lui-Lindberg explains why FP&A can no longer take a narrow view of its own role. FP&A is obviously concerned with financials; however FP&A can no longer take…
June 5, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together
In an IBM Planning Analytics Tips & Tricks video, I demonstrated the concept of using words to manipulate your views. This approach also applies to entering data. All of you know that you can enter data by typing a number into a…
June 2, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Data Load Process
In an IBM Planning Analytics Tips & Tricks video, I showed how to use a drag and drop approach to load data into a cube. Since that time, the wizard has been updated to allow you to save your import as a…
May 26, 2020

FP&A Done Right: 3 Words for a COVID-19 World – “Flexible Budget Variance”
This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. It is part of a series of blogs from Adaptive Insights designed to help customers weather the storm brought by the COVID-19 pandemic. With the COVID-19 pandemic…
May 22, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The CellValueN Formula
Rules in IBM Planning Analytics allow you to reference components of a cube as part of your formula … either from the cube you are currently in or from another cube. This is done via the use of the DB function. The…
May 19, 2020

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Max Number of ELSEIF
Most of you know the concept of an IF statement within TurboIntegrator IF (expression); statement1;ENDIF; … and most of you also know the concept of nested-IF statements IF (expression); statement1;ELSEIF (expression); statement2;ENDIF; … and most of you also know the concept of…
May 12, 2020

Tech Bulletin: New IBM Planning Analytics Features for 2020
IBM introduces new features for Planning Analytics in releases throughout the year. We publish IBM Planning Analytics Tips & Tricks on these features every Tuesday in our Knowledge Center. If you would like to receive these in your inbox every Tuesday, you…
May 11, 2020

FP&A Done Right: The Office of Finance in the COVID-19 Economy
Three months ago, we could not have imagined life as it is today. We’re experiencing an economic slowdown that none of us have seen before. Not a single industry is immune from the impact of the U.S. and other countries sheltering-in. Many…