4.1 Overview of Dimension Population

In OFSAA, hierarchies are defined and managed through the common infrastructure, Dimension Management User Interface. Before use in ALMBI, the related Parent or Child Hierarchy Data must first be converted to a flattened and level-based format. The dimension population process involves both the hierarchy flattening process and movement of the Dimension Data from Processing Dimension tables to the Common Reporting Dimension tables, shared by all the OFSAA BI Applications.

Figure 4-1 Dimension Population

The Dimension Population Process has the two components.