5.15 Hierarchy Transformation

Hierarchy Flattening Transformation is used to move the hierarchy data from the parent child storage structure in EPM AMHM (Attribute, Member and Hierarchy Management) model to a level based storage structure in OFSAA BI applications. In EPM AMHM model, hierarchy data for any hierarchy created on seeded or user defined dimensions using the AMHM is stored within hierarchy tables of respective dimensions. This is moved to the REV_HIER_FLATTENED table in OFSAA BI applications after flattening by the Hierarchy flattening process.

batch_hierTransformation is a seeded Data Transformation program installed as part of the OFSAA BI applications installers.

Note:

Refer to Support Note 1586342.1, if Hierarchy Filter is not reflecting correctly after making the changes to underlying Hierarchy.