5.5 Support of Multiple Hierarchies

Multiple Hierarchies on a single dimension can be set up in ALMBI.

One can view multiple hierarchies in a report in a single view through the following steps:

1. Create your product hierarchy (for example, Product Hierarchy 1).
2. Perform Hierarchy Transformation.
3. Run the SCD Process.
4. Run the ALM Results Transformation process for a particular As of Date.

Records will be populated into the relevant FACT tables for the mentioned hierarchy and As-of-Date. Similarly, perform these steps for Multiple Hierarchies and run the ALMBI Transformation accordingly. From this point, you will be able to select any of the multiple hierarchies while designing a new report.