This cube dimension represents the intercompany elimination rule and is based on the IFS Applications dimension DIM_INTERCOMPANY_ELIM_RULE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
The natural parent is master company, i.e each master company has its own set of rules.
Attribute | Hierarchy | Description |
Elim Account From | NO | Eliminitation Account No From |
Elim Account To | NO | Elimination Account No to |
Elim Posting Method | NO | Posting Method Type Code |
Elim Rule Code Desc | NO | Built as CODE + ' - ' + DESCRIPTION |
Elim Rule Code | NO | Represents the CODE of the dimension, i.e. Elimination Rule Code value |
Elim Rule Desc | NO | Represents the DESCRIPTION of the Transaction Type |
Matching Account From | NO | Matching Account No From |
Matching Account To | NO | Eliminitation Account No To |
Valid From Period | NO | Rule valid from period YYYY-MM |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_INTERCOMPANY_ELIM_RULE_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.176 Load IFSAppl_DIM_INTERCOMPANY_ELIM_RULE_BI.dtsx | IFSAppl_DIM_INTERCOMPANY_ELIM_RULE_BI |
T - DW | 2.1.176 Load Dw_DIM_INTERCOMPANY_ELIM_RULE.dtsx | Dw_DIM_INTERCOMPANY_ELIM_RULE |
L - DM | 3.1.176 Load Dm_DIM_INTERCOMPANY_ELIM_RULE.dtsx | Dm_DIM_INTERCOMPANY_ELIM_RULE |