1. User Guide
  2. Fact Ledger Population
  3. Tables Used by the Fact Ledger Population Transformation
  4. Hierarchy Configuration for LOB and Legal Entity

8.2.2 Hierarchy Configuration for LOB and Legal Entity

  • DIM_ORG_STRUCTURE: The hierarchy to be built for the DIM_ORG_STRUCTURE is a parent-child hierarchy. The parent node of the root has to be kept blank in the V_PARENT_CODE column. The hierarchy can then be built appropriately by putting a child node - parent node combination in the V_ENTITY_CODE and V_PARENT_CODE columns of the DIM_ORG_STRUCTURE table. This metadata setup supports only one hierarchy for Legal Entity.

The new data transformation FN_ORG_PARENT_CHILD has to be re-executed with respect to any change in the DIM_ORG_STRUCTURE table. This process loads the ORG_STR_PARENT_CHILD_RELATION table data, which is sourced from the DIM_ORG_STRUCTURE table.