This cube dimension represents the group Consolidation structure node and is based on the IFS Applications dimension DIM_CONSOL_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 structure node values.
Sort Order of attributes Structure Node Code Desc is based on the definition of the Consolidation Structure in IFS Applications as it looks in the last consolidation period.
Attribute | Hierarchy | Description |
Structure | NO | Structure ID |
Structure Node Code | NO | Represents the CODE of the dimension, i.e. Structure Node Code value |
Structure Node Desc | NO | Represents the DESCRIPTION of the Structure Node value |
Structure Node Code Desc | NO | Built as Sort Order-CODE + ' - ' + DESCRIPTION |
Structure - Code - Desc | NO | Built as STRUCTURE ID + ' - ' +CODE + ' - ' + DESCRIPTION |
Structure Node Type | NO | Represents the node type of the Structure Node |
StructureNodeHy | YES | Hierachy defined as "Structure" -> "Structure Node Code Desc" |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_CONSOL_STRUCTURE_NODE_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.169 Load IFSAppl_DIM_CONSOL_STRUCTURE_NODE_BI.dtsx | IFSAppl_DIM_CONSOL_STRUCTURE_NODE_BI |
T - DW | 2.1.169 Load Dw_DIM_CONSOL_STRUCTURE_NODE.dtsx | Dw_DIM_CONSOL_STRUCTURE_NODE |
L - DM | 3.1.169 Load Dm_DIM_CONSOL_STRUCTURE_NODE.dtsx | Dm_DIM_CONSOL_STRUCTURE_NODE |