What are Alternate Hierarchies and How are They Used

Alternate hierarchies provide information on a segment of your hierarchy and in some cases only certain members of that segment (based on how you set up the hierarchy). Alternate hierarchies use the same set of books for the alternate hierarchy and the segment the alternate hierarchy is based off.

Use Alternate Hierarchies to summarize specific members of a dimension for more granular reporting needs. For example, you need to combine Company cost centers in 3 different ways for reporting purposes. So, you create 3 different alternate hierarchies on the Company dimension.

Alternate hierarchy #1 - contains only those cost centers for management reporting

Alternate hierarchy #2 - contains cost centers for division reporting

Alternate hierarchy #3 - cost centers for legal entity reporting