Cube Dimension - Structure Node

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.

ATTRIBUTES

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"

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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