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
Tips and Tools for Working from Home
Whether you are a “work from home” veteran, or are new to working from home, most of us are not used to working from home five days a week, with our families also at home. The situation we’re faced with now is…
May 27, 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…
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…
May 8, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: New Excel Feature – Map Charts
One of the new features in Excel is the ability to create Map Charts to compare values and show categories across geographical regions. If you have your own set of data to use skip to step 3. Otherwise, we can accomplish this…