This cube dimension represents the group Consolidation parallel structure node and is based on the IFS Applications dimension DIM_PAR_STRUCTURE_NODE. 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 node values.
Attribute | Hierarchy | Description |
Parallell Structure | NO | Structure ID |
Par Struct Node Code | NO | Represents the CODE of the dimension, i.e. Structure Node Code value |
Par Struct Node Desc | NO | Represents the DESCRIPTION of the Structure Node value |
Par Struct Code Desc | NO | Built as CODE + ' - ' + DESCRIPTION |
Par Struct - Code - Desc | NO | Built as STRUCTURE ID + ' - ' +CODE + ' - ' + DESCRIPTION |
Par Struct Node Type | NO | Represents the node type of the Structure Node |
ParStructureNodeHy | YES | Hierachy defined as "Parallel Structure" -> "Par Struct Code Desc" |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_PAR_STRUCTURE_NODE_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.185 Load IFSAppl_DIM_PAR_STRUCTURE_NODE_BI.dtsx | IFSAppl_DIM_PAR_STRUCTURE_NODE_BI |
T - DW | 2.1.185 Load Dw_DIM_PAR_STRUCTURE_NODE.dtsx | Dw_DIM_PAR_STRUCTURE_NODE |
L - DM | 3.1.185 Load Dm_DIM_PAR_STRUCTURE_NODE.dtsx | Dm_DIM_PAR_STRUCTURE_NODE |