Cube Dimension - Parallel Structure Sub Level

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.

ATTRIBUTES

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

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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