Cube Dimension - Parallel Structure

This cube dimension represents the group Consolidation parallel structure and is based on the IFS Applications dimension DIM_PAR_CONSOL_STRUCTURE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is master company, i.e. each master company has its own set of parallel structure values.

ATTRIBUTES

Attribute Hierarchy Description
Parallel Structure NO Key. Built as MASTER COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION
Parallel Structure Code NO Represents the CODE of the dimension, i.e. Structure Code value
Parallel Structure Desc NO Represents the DESCRIPTION of the Structure value
Parallell Structure Code Desc NO Built as CODE + ' - ' + DESCRIPTION

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_PAR_CONSOL_STRUCTURE_BI GROCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.173 Load IFSAppl_DIM_PAR_CONSOL_STRUCTURE_BI.dtsx IFSAppl_DIM_PAR_CONSOL_STRUCTURE_BI
T - DW 2.1.173 Load Dw_DIM_PAR_CONSOL_STRUCTURE.dtsx Dw_DIM_PAR_CONSOL_STRUCTURE
L - DM 3.1.173 Load Dm_DIM_PAR_CONSOL_STRUCTURE.dtsx Dm_DIM_PAR_CONSOL_STRUCTURE