IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Combining the DIMIX and DIMNM Functions
In a previous blog, we defined how to convert an alias back to the original element name within a TurboIntegrator script. The DimensionElementPrincipalName function is only valid for TI scripts, so what happens if you need to perform the same logic in…
January 11, 2022
Technical Bulletin: Update to Log4j Vulnerability’s Impact on IBM Planning Analytics
Updated December 21, 2021 Summary Multiple vulnerabilities have been discovered involving Apache Log4j. This was originally known as CVE-2021-44228, but it has been expanded to also include both CVE-2021-45046 and CVE-2021-45105. Apache Log4j is used by IBM Planning Analytics Workspace as part of its…
December 21, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator
Have you ever needed to convert an alias back to the original element name within an IBM Planning Analytics TurboIntegrator script? Maybe you have a data source where the value entails an alias but further logic references the element code. You can…
December 21, 2021
Technical Bulletin: Apache Log4j Vulnerability Impact on IBM Planning Analytics Models
Summary A vulnerability has been discovered involving Apache Log4j (CVE-2021-44228). Apache Log4j is used by IBM Planning Analytics Workspace as part of its logging infrastructure. This may have a significant impact on your existing models. Details This issue impacts all users currently…
December 15, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Maps
IBM Planning Analytics Workspace (PAW) version 69 introduced a new map visualization for your charts. In addition to improving the identification of the geography elements, this new visualization introduces additional features such as … The ability to search for locations within the…
December 14, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Pie Percent or Value?
Pie charts are one of the most common types of data visualizations. A pie chart is defined as a component report, which means that it is design to show part-to whole relationships. This approach makes it easy to get a general sense of…
November 16, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1Ellist
Have you ever wanted to use Excel to create a list of elements within an IBM Planning Analytics dimension? If so, the TM1ELLIST function is your answer! This function is used to return a list of elements with parameters to define the look of…
October 26, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Stacked Columns Dimension Order
Column charts are one of the most common types of data visualizations and stacked columns are simply an expansion of the columns. The stacking allows you to compare two sets of data within the same chart. But have you ever thought about how…
October 19, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Approaches to Allocations in Planning Analytics
Many Revelwood clients have allocations models within their IBM Planning Analytics environment. Some – like those we highlighted in a recent webinar – have complex and/or unique approaches to their allocation models. During the webinar we received several questions. Here are a…