This cube dimension represents the group Consolidation parallel sub level and is based on the IFS Applications dimension DIM_PAR_STRUCT_SUB_LEVEL. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Natural parent is company and structure, i.e. each master company structure has its own set of parallel structure sub level values.
Attribute | Hierarchy | Description |
Parallell Structure | NO | Structure ID |
Par Struct Sub Level Code | NO | Represents the CODE of the dimension, i.e. Structure Sub Level value |
Par Struct Sub Level Desc | NO | Represents the DESCRIPTION of the Structure Sub Level value |
Par Struct Sub Level Code Desc | NO | Built as CODE + ' - ' + DESCRIPTION |
Par Struct - Code - Desc | NO | Built as STRUCTURE ID + ' - ' +CODE + ' - ' + DESCRIPTION |
Par Struct Sub Level Type | NO | Represents the node type of the Structure Sub Level |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_PAR_STRUCT_SUB_LEVEL_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.186 Load IFSAppl_DIM_PAR_STRUCT_SUB_LEVEL_BI.dtsx | IFSAppl_DIM_PAR_STRUCT_SUB_LEVEL_BI |
T - DW | 2.1.186 Load Dw_DIM_PAR_STRUCT_SUB_LEVEL.dtsx | Dw_DIM_PAR_STRUCT_SUB_LEVEL |
L - DM | 3.1.186 Load Dm_DIM_PAR_STRUCT_SUB_LEVEL.dtsx | Dm_DIM_PAR_STRUCT_SUB_LEVEL |