Technical Bulletin: Earlier Security Change Impacting MDX Reverted
IBM is undoing a recent security change in the next release of IBM Planning Analytics. In late June we issued a technical bulletin about version 2.0.9 of Planning Analytics that changed the way MDX expressions are generated for dimensions that have security…
July 10, 2020
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
Technical Bulletin: Security Change Impacts MDX
IBM has decided to revert the change in behavior that is described in this tech bulletin. The change will be made in version 2.0.9.2 and it is expected to be released by the end of July. For more information, please reference IBM's…
June 11, 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
FP&A Done Right: What Must FP&A Do Differently to Make Planning a Success
This is a guest blog post from our partner Adaptive Insights, written by Anders Liu-Lindberg. Lui-Lindberg explains why FP&A can no longer take a narrow view of its own role. FP&A is obviously concerned with financials; however FP&A can no longer take…
June 5, 2020
Adaptive Insights Tips & Tricks
Adaptive Insights Tips & Tricks: Virtual Versions and Neutral Exchange Rate
Many companies with multiple currencies and exchange rates within the Adaptive Insights Planning instance require a methodology to compare the current year budget to the current year actuals while maintaining the exchange rate utilized to create the budget. This is sometimes referred…