This cube dimension represents the group Consolidation parallel structure and is based on the IFS Applications dimension DIM_PAR_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 parallel structure values.
Attribute | Hierarchy | Description |
Parallel Structure | NO | Key. Built as MASTER COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION |
Parallel Structure Code | NO | Represents the CODE of the dimension, i.e. Structure Code value |
Parallel Structure Desc | NO | Represents the DESCRIPTION of the Structure value |
Parallell Structure Code Desc | NO | Built as CODE + ' - ' + DESCRIPTION |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_PAR_CONSOL_STRUCTURE_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.173 Load IFSAppl_DIM_PAR_CONSOL_STRUCTURE_BI.dtsx | IFSAppl_DIM_PAR_CONSOL_STRUCTURE_BI |
T - DW | 2.1.173 Load Dw_DIM_PAR_CONSOL_STRUCTURE.dtsx | Dw_DIM_PAR_CONSOL_STRUCTURE |
L - DM | 3.1.173 Load Dm_DIM_PAR_CONSOL_STRUCTURE.dtsx | Dm_DIM_PAR_CONSOL_STRUCTURE |