Rounding in TM1 – The Complete Guide!
ROUND and ROUNDP are often confused and users expect them to behave the same as the Excel function. They are very similar but are different to the Excel treatment. Here is a complete explanation of both functions, a comparison to Excel ROUND and screenshots of the usage of both functions.
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.
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