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.
Setting Dimension Order for a TM1 Cube
Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.
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