3.4 Hierarchy

Standard dimensions such as Product, Organization, Common COA, and General Ledger are populated through the AMHM layer of Profitability Management application (OFS PFT). OFS EFPA assumes that only one hierarchy is present for each dimension in the AMHM layer. This Hierarchy of data for each Dimension is populated in the Dimension Tables through SCDs.

An Entry in the SETUP_MASTER table is required for the hierarchy for which the members are to be loaded in the dimension tables. One properly constructed Hierarchy ID should be given in the COMPONENT_VALUE column for each dimension.