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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Max Number of ELSEIF
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: The CellValueN Formula
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Using Words and Numbers Together
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: The Excel DATE Function
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: The Excel FORMULATEXT Function
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Excel’s FILTER Function
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 1
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 … [Read more...] about IBM Planning Analytics Tips & Tricks: Merge an Icon and a Button, Part 2
IBM Planning Analytics Tips & Tricks: Comparing Sandboxes
Many of you know that you can create personal what-if scenarios in IBM Planning Analytics via the sandbox feature. This approach allows you quickly replicate an entire environment … [Read more...] about IBM Planning Analytics Tips & Tricks: Comparing Sandboxes