IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Modelling Books
Did you know IBM Planning Analytics Workspace (PAW) update 57 introduced a new type of PAW book? This new type of book is called a “Modelling Book.” A modelling book can be created by selecting the “Data and Models” tile at the…
January 18, 2022
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
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: TM1PRIMARYDBNAME
Did you know there is a function to dynamically retrieve your database server name in IBM Planning Analytics for Excel (PAx)? When creating reports and input templates in Planning Analytics for Excel you must reference the TM1 server name you are pulling/pushing…
January 4, 2022
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: How to Download IBM Software
IBM has recommended a new IBM Planning Analytics Workspace patch to address the recently discovered Apache log4j vulnerability. Many of our clients have asked questions about how to download their software from IBM. Here are the basic steps you can take to download…
December 28, 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
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: Fill Function
Have you ever been in a situation where you need to add extra characters to a string in IBM Planning Analytics? Maybe you need ten characters, but the data source value only has seven characters. You can resolve this situation via the…
December 7, 2021
IBM Planning Analytics Tips & Tricks
Questions on Virtual Hierarchies in IBM Planning Analytics
Virtual hierarchies in IBM Planning Analytics are not as well understood as you might suspect. We’ve found that many Planning Analytics users don’t understand what virtual hierarchies are, how to use them, and when to use them. We’re here to answer your…
November 30, 2021
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: Displaying Percentages on a Planning Analytics Workspace (PAW) Pie Chart
In a recent blog post we discussed pie charts and how you can show data points or percentages in an IBM Planning Analytics Workspace (PAW) pie chart. We also have an IBM Planning Analytics Tips & Tricks video that shows how easy…