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
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
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Create New Books with the Diamond Icon
IBM Planning Analytics pages are defined as “books.” Each book can have multiple components on it (a view, an image, etc.) and the book can contain multiple sheets. Most users create books by clicking on the “New” icon from the Welcome screen…
April 7, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Admin Server Recycle
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. This blog post explains how to do server recycle through the new…
March 24, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks Video: The Hold Feature
Today’s IBM Planning Analytics Tips & Tricks video focuses on the new hold feature in Planning Analytics. Watch the video and you’ll see our Director of FP&A Technology, Lee Lazarow, demonstrate how to use the hold feature, which gives you the ability…