I have a report based off of a cube in TM1 with a metric hierarchy.
Metric A
Metric B
Metric B1
Metric B2
Metric C
Metric D
When I run the report and select Metric A, B, B1, B2, D. The report looks like and displays in my crosstab (rows) in that same order. However, when my co worker runs this report, she sees Metric A, B, D, B1, B2. Does anyone know why? It seems like when she runs the report the lower level items are placed at the end of the display. Why would she see something different? Is this a setting?
I used the "hierarchize(set expression)" function and this now seems to work properly.