Cube Dimension - Intercompany Elim Rule

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.

ATTRIBUTES

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 

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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