
IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: PAW Chart Multicolors
One of the visualizations in Planning Analytics is a column chart. This type of chart is a good way to compare items since all the lines are in proportion to each other. An easy way to create a column chart is to…
June 14, 2022

IBM Planning Analytics Tips & Tricks
IBM Planning Analytics Tips & Tricks: NumberToStringEx
IBM Planning Analytics has the ability to export data to flat files with the use of the ASCIIOUTPUT and TEXTOUTPUT functions. However, these two functions will only accept string variables. That means that numeric data will first need to be converted to…
June 7, 2022

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…