Cube Dimension - Parallel Structure Node

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.

ATTRIBUTES

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"

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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