IBM Planning Analytics Tips & Tricks
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
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
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
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…
May 5, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Sparklines
Are you familiar with Sparklines, a rarely used feature in Excel? What happens when you’d like to provide a visual representation of data but don’t necessarily want, or have the space, for a big chart? Sparklines may be a viable solution. To…
April 28, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Bulk Load Template for Cubes with Indices
Do you have cubes in your IBM Planning Analytics (PA) model that allow for planning with line item detail? The struggle you may come across in creating a template in Excel that automatically loads to the next available line is that such…
April 21, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: Formatting Views in Planning Analytics Workspace
In today’s IBM Planning Analytics Tips & Tricks video, Lee Lazarow, our PF&A Technology Director, demonstrates how to format views in Planning Analytics Workspace (PAW). By using formatting, you will make your views easier to read so your users can spend more…