IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 2
In an earlier post, I showed how to merge a button onto an image in IBM Planning Analytics to create an easy-to-navigate user experience. However, as a developer I may forget which images are just images and which images contain buttons. To…
July 7, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1
User experience is an important factor when designing any system. One of the most important aspects of the experience is the ease in which users can navigate from one page to another. In situations where an IBM Planning Analytics Workspace (PAW) book…
June 30, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Excel’s FILTER Function
Have you ever wanted to filter a list of data to look at a subset of the entire table? Many of you know that you can use the filter button within Excel’s data section to do this. But what if you wanted…
June 23, 2020
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function
Have you ever looked at a value on a report and wanted to know the formula that was used, even though you may not have access to the report? Have you ever wanted to easily include a formula as part of the…
June 16, 2020
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…