CreateHierarchyByAttribute Function in TM1: Syntax and Use
Here is a great way to create virtual dimensions in TM1 based on attributes. These allow you to intersect multiple virtual dimensions from the same physical dimensions in a PAW or PAX report. Here we discuss the CreateHierarchyByAttribute function and give an example on how to use it.
Date and Time Functions for Easy Date Manipulation
Manipulating dates and times in TM1 has always been horrible. Here we discuss the time manipulation methods available from TM1 v10.2 onwards. These include NewDateFormatter, FormatDate and ParseDate. With them you can even change time from one time zone to another.
Get started with our complete TM1 courses
Discover the potential and power of business intelligence tools that can be sculpted and moulded to meet any business requirement