3.1 Dimension Data Loader

The Dimension Loader procedure populates Dimension Members, Attributes, and Hierarchies from Staging Dimension Tables into the Dimension Tables registered with Profitability and Balance Sheet Management (PBSM) Cloud Service. You can view the Members and Hierarchies loaded by the Dimension Loader though the PBSM Screens.

The Data File Specification is not applicable to Dimension Data Loaders. The file format and the file names are static in nature.

The following illustration depicts the process of Dimension Loading.

Figure 3-1 Dimension Loading Process

The Dimension Loader is used to:

• Load the Dimension Members and their Attributes from the Staging area into the Dimension Tables that are registered with PBSM Cloud Service framework.
• Create Hierarchies in PBSM Cloud Service.
• Load Hierarchical relationships between Members within the Hierarchies from the Staging area into PBSM Cloud Service.

The following are the features of Dimension Loader:

• Multiple Hierarchies can be loaded from Staging Tables.
• Validations of Members and Hierarchies are similar to that of being performed within the PBSM Screens.

Before you start the Dimension Loader, you must upload the Data Files that have the Dimension details. The following is a list of sample files that you can use to build the Dimension Data. The name of the Data Files must be same as mentioned below and the File Extension must be .DAT. Click on each Data File Name to open a Sample Data File.

Stage Dimension Loaders (Task 1):

• input_stg_dimensions_attr_intf.dat
• input_stg_dimensions_b_intf.dat
• input_stg_dimensions_tl_intf.dat
• input_stg_dimensions_hier_intf.dat

Stage Hierarchy Loaders (Task 2):

• input_stg_hierarchies_intf.dat
• input_stg_hierarchy_levels_intf.dat

To load the Dimensions, perform the following steps:

1. Define a new Batch and save it.
2. Add the following Tasks to the above Batch:

   Table 3-1 Dimension Loading Process Tasks

   Task Code	Task Name	Component	Parent Task
   1	Stage Dimension Loader	Stage Dimension Loader
   2	Stage Hierarchy Loader	Stage Hierarchy Loader	1
   3	Stage DRM Loader	Stage DRM Loader	2

   Note:

   The above Tasks must be executed in the same order.

   The Stage DRM Loader allows you to select a Dimension. You can select both Simple and Key Dimensions.

3. Execute the Batch.

For detailed instructions on Creating a Batch, Defining a Task, Execute the Task, and Schedule a Batch, see the Scheduler Services User Guide.