|
In Multiple and Alternate path hierarchy-
- Each level in the tree can have more than one possible parent level AND
- Each instance can belong to more than one instance in the parent dimension level AND
- Criteria for analysis is same.
An alternate path hierarchy is, when the hierarchy paths merge at certain points (generally once at the higher levels), whereas it is called multiple path, when the paths do not merge. As an example
The following hierarchy path is a alternate path hierarchy, whereby sales office level belongs to two different levels as a parent (direct sales channel area and indirect sales channel area), but the paths merge at the level of sales region. Essentially the hierarchy is taking alternate paths to reach at the same level in the end.
Sales office—>direct sales Channel Area—>direct sales channel sector—>Direct sales Channel Zone—> Sales Region
Sales Office—>Indirect sales Channel Area—>Indirect sales Channel sector—> Indirect sales Channel Zone—> Sales Region
The following hierarchy will be the multiple path hierarchy. In this example the paths are not merging.
Sales office—>direct sales Channel Area—>direct sales channel sector—>Direct sales Channel Zone—> Sales Region
Sales Office—>Indirect sales Channel Area—>Indirect sales Channel sector—> Indirect sales Channel Zone—> Indirect Sales Region
As you see in the above examples- though the paths are either alternate OR multiple, but the criteria for analysis is same and that is the sales channel and related measures. The next topic is parallel hierarchies, which is combination of the multiple OR alternate path hierarchies, but where the criteria is also different.
|
