Alternate hierarchies

[viswaraju]

please can explain me about the allternate hierarchies with an example and where it can be used and how it can be used?

thanking you

[Steve Rowe]

An alternate hierarchy is just a different way of adding the elements together.
For example you could add Jan, Feb, Mar, Apr.... Dec together to get the Full Year total. You could also add together Jan and Feb to get Feb YTD, that's an alternate hierarchy.
You could also have alternate hierarchies in the chart of accounts, Account codes adding together to form a Management P and L or a Statutory P and L.

If you are talking pure TM1 then there is nothing special about an alternate hierarchy, you just build them...

HTH
Steve

[kpk]

In a TM1 dimension you can build up unlimited hierarchies from the same elements:
E.g.

Friend total
Anna
Judith
Susan
John
Steve
Andrew

Friends by age
0-20
Anna
John
21-40
Judith
Steve
41-
Susan
Andrew

Friends by city
Budapest
Anna
John
Susan
London
Judith
Steve
Andrew

Some advantages:
- Multiple hierarchies gives option to analyse and structure the data in many ways.
- Any number you input on any N level element is automatically aggregated to all alternative C elements.
One "issue" could be:
- Hierarchies are not time dependent in TM1. If you change the hierarchy (e.g. Andrew move to Budapest) then all the historical data of Andrew will be shown under Budapest.
To avoid this you can split the 2 information into 2 dimensions: friends and location ... but this is an other topic.

Regards,

Peter