This cube dimension represents the group Consolidation structure and is based on the IFS Applications dimension DIM_CONSOL_STRUCTURE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is master company, i.e. each master company has its own set of structure values.
Attribute | Hierarchy | Description |
Structure | NO | Key. Built as MASTER COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION |
Structure Code | NO | Represents the CODE of the dimension, i.e. Structure Code value |
Structure Desc | NO | Represents the DESCRIPTION of the Structure value |
Structure Code Desc | NO | Built as CODE + ' - ' + DESCRIPTION |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_CONSOL_STRUCTURE_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.168 Load IFSAppl_DIM_CONSOL_STRUCTURE_BI.dtsx | IFSAppl_DIM_CONSOL_STRUCTURE_BI |
T - DW | 2.1.168 Load Dw_DIM_CONSOL_STRUCTURE.dtsx | Dw_DIM_CONSOL_STRUCTURE |
L - DM | 3.1.168 Load Dm_DIM_CONSOL_STRUCTURE.dtsx | Dm_DIM_CONSOL_STRUCTURE |