3.2.3.1.1 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. HIERARHY_CODE must be in capital letters. 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.

Attributes Of Key Dimensions

Data for mandatory attributes of Key Dimensions must be provided in the STG_DIMENSIONS_ATTR_INTF file.

Table 3-4 Attributes of Key Dimensions

Dimension Id	Dimension Name	Attribute Id	Attribute Label	Attribute Name	Attribute Data Type	Attribute Dimension Name	Mandatory Attribute?
0	Financial Element	5000	WEIGHTING_FINANCIAL_ELEM_ID	Weighting Financial Element	Dimension	Financial Element	N
0	Financial Element	5001	ACCOUNT_TYPE_ID	Account Type	Dimension	Account Type	Y
0	Financial Element	5002	AGGREGATE_METHOD_ID	Aggregate Method	Dimension	Aggregate Method	Y
0	Financial Element	5004	COLUMN_PROPERTY_ID	Column Property	Dimension	FE Column Property	Y
0	Financial Element	5050	ROLLUP_SIGNAGE_ID	Rollup Signage	Dimension	Rollup Signage	Y
1	Organizational Unit	5030	OFFSET_ORG_UNIT_ID	Offset Organizational Unit	Dimension	Organizational Unit	N
2	General Ledger Account	5020	ACCRUAL_BASIS_ID	Accrual Basis	Dimension	Accrual Basis	N
2	General Ledger Account	5021	COMMON_COA_ID	Common Chart of Account	Dimension	Common Chart of Accounts	Y
2	General Ledger Account	5052	ROLLUP_SIGNAGE_ID	Rollup Signage	Dimension	Rollup Signage	Y
2	General Ledger Account	5057	ACCOUNT_TYPE_ID	Account Type	Dimension	Account Type	Y
2	General Ledger Account	5058	RECONCILIATION_PRODUCT_ID	Reconciliation Product	Dimension	Product	Y
3	Common Chart of Accounts	5040	ACCOUNT_TYPE_ID	Account Type	Dimension	Account Type	Y
3	Common Chart of Accounts	5041	ACCRUAL_BASIS_ID	Accrual Basis	Dimension	Accrual Basis	N
3	Common Chart of Accounts	5053	ROLLUP_SIGNAGE_ID	Rollup Signage	Dimension	Rollup Signage	Y
4	Product	5010	ACCRUAL_BASIS_ID	Accrual Basis	Dimension	Accrual Basis	N
4	Product	5011	COMMON_COA_ID	Common Chart of Account	Dimension	Common Chart of Accounts	Y
4	Product	5054	ROLLUP_SIGNAGE_ID	Rollup Signage	Dimension	Rollup Signage	Y
4	Product	5059	ACCOUNT_TYPE_ID	Account Type	Dimension	Account Type	Y
4	Product	5060	AMENABILITY_CAT_ID	Amenability Category	Dimension	Product Amenability Category	Y
4	Product	5061	INT_SENSITIVE_CAT_ID	Interest Rate Sensitivity	Dimension	Product Interest Sensitive	Y
4	Product	5064	PRODUCT_LIFE_TIME_VALUE	Product Life Time Value	Number	Product	N
5	Legal Entity	5062	RATE_DATA_SOURCE_ID	Rate Data Source	Dimension	Rate Data Source	Y
5	Legal Entity	5063	GROUP_COMPANY_PARTY_CODE	Group Company Party	String	Customer Affiliate Category	Y

Note:

Ensure that attribute values are present as members in their corresponding dimensions when an attribute’s data type is Dimension. For example, if the COMMON_COA_ID attribute for PRODUCT_ID 123 is 345, then 345 must be present as a member of the Common COA dimension.