1. User Guide
  2. Data File Specification
  3. Data Loaders
  4. Dimension Data Loader

Dimension Data Loader

The Dimension Loader procedure populates Dimension Members, Attributes, and Hierarchies from Staging Dimension Tables into the Dimension Tables registered with the Cloud Service. You can view the Members and Hierarchies loaded by the Dimension Loader though the application 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 11-8 Dimension Loading Process


This illustration depicts the process flow of 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 OFS Cloud Service framework.
  • Create Hierarchies for Key Dimensions in the Cloud Service.
  • Load Hierarchical relationships between Key Dimension Members within the Hierarchies from the Staging area into the Cloud Service.

The following are the features of Dimension Loader:

  • Loading Simple Dimensions from Staging Tables.
  • Multiple Hierarchies can be loaded from Staging Tables.
  • Validations of Members and Hierarchies are similar to that of being performed within the Cloud Service Screens.

Before you start the Dimension Loader, you must upload the Data Files that have the Dimension details.

As part of the File Definition, it is required Dimension Identifier for both Key and Simple Dimensions.

To get the correct DIMENSION ID to be used for the data file definition, you should use the SQL Query Browser and following query under OFSAAMETA schema the REV_DIMENSIONS_B table:
SELECT
dimension_id,
member_b_table_name,
member_tl_table_name,
dimension_active_flag,
simple_dimension_flag,
user_defined_flag,
write_flag,
dimension_editable_flag,
key_dimension_flag
FROM
ofsaameta.rev_dimensions_b
WHERE
dimension_active_flag = 'Y';

Then for the dimension table desired, available in REV_DIMENSIONS_B.MEMBER_B_TABLE_NAME or REV_DIMENSIONS_B.MEMBER_TL_TABLE_NAME table columns, the End User should pick up the correct value displayed in REV_DIMENSIONS_B.DIMENSION_ID to be used for correct input file definition.

The following sections list the 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.