5.1 Dimension Loaders

The Dimension Loader procedure populates dimension members, attributes and hierarchies from Staging dimension tables into dimension tables registered within OFSAAI AMHM framework. Users can view the members and hierarchies loaded by the dimension loader through AMHM screens.

Note:

The dimension loaders (drmDataLoader, STGDimDataLoader, and simpledimloader) load the strings into one target language only, the target language is derived from the database-login-session using USERENV.

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

Topics:

• Enhancements to Support Alphanumeric Code in Dimensions
• Tables that are Part Of Staging
• Dimension Load Procedure
• Setting up Dimension Loader
• Executing the Dimension Load Procedure
• Exception Messages
• Executing the Dimension Load Procedure using Master Table approach
• Truncate Stage Tables

The dimension loader is used to:

• Load dimension members and their attributes from the staging area into Dimension tables that are registered with the OFSAAI AMHM framework.
• Create hierarchies in AMHM.
• Load hierarchical relationships between members within hierarchies from the staging area into AMHM.

Some of the features of the dimension loader are:

• Multiple hierarchies can be loaded from staging tables.
• Validations of members and hierarchies are similar to that of being performed within AMHM screens.
• Members can be loaded incrementally or fully synchronized with the staging tables.

Figure 5-1 Dimension Loader