For Key Dimensions

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. The value of column HIERARCHY_CODE must not contain space in files STG_DIMENSIONS_HIER_INTF, STG_HIERARCHIES_INTF and STG_HIERARCHY_LEVELS_INTF. 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

Note:

Any column description that contains a ",", then it should be enclosed within "" (double quotes). For example, Account, Type should be "Account, Type".

To load the Dimensions:

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

   Table 3-3 Dimension Loading Process Tasks

   Task Code	Task Name	Component	Parameters	Parent Task
   1	Stage Dimension Loader	Stage Dimension Loader	All parameters are automatically generated.
   2	Stage Hierarchy Loader	Stage Hierarchy Loader	All parameters are automatically generated.	1
   3	Stage DRM Loader	Stage DRM Loader	Dimension Name: Select the relevant one or more dimensions. Sync Stage and Dimension: Yes: The record(s) that is/are already present will be overwritten by the incoming dimension loader. No: The new records will be merged to the existing records. Force Member Delete: This is used only when the above flag is Yes. Yes: This allows you to delete a members even if is referred in hierarchies. No: No records will be deleted.	2

   Note:

   The above Tasks must be executed in the same order.

   The File to Stage task must precede the Stage to Processing task in a batch.

   The Stage DRM Loader allows you to select a Dimension.

3. Execute the Batch.

   Note:

   This method of loading dimensions will be deprecated in future releases. Recommended approach is in the following section.

Dimension Loader with ZIP File Support

To to upload the Dimension data using a zip file:

1. Create a Folder.
2. Follow the naming convention for the DAT files as follows and save them:
   • DIMENSIONS_ATTRIBUTES
   • DIMENSIONS_BASE
   • DIMENSIONS_HIERARCHIES
   • DIMENSIONS_TRANSLATION
   • HIERARCHIES
   • HIERARCHY_LEVELS
3. Place all the DAT files inside the folder.
4. Zip the folder.
5. Create a Batch.
6. Create a Task with the Component name as Dimension and Hierarchy Loader.
7. Enter the Zipped Folder Name along with the extension. For example, DIMENSIONS.ZIP.
8. Execute the Batch.

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