Cube Dimension - Structure

This cube dimension represents the group Consolidation structure and is based on the IFS Applications dimension DIM_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 structure values.

ATTRIBUTES

Attribute Hierarchy Description
Structure NO Key. Built as MASTER COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION
Structure Code NO Represents the CODE of the dimension, i.e. Structure Code value
Structure Desc NO Represents the DESCRIPTION of the Structure value
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_CONSOL_STRUCTURE_BI GROCDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.168 Load IFSAppl_DIM_CONSOL_STRUCTURE_BI.dtsx IFSAppl_DIM_CONSOL_STRUCTURE_BI
T - DW 2.1.168 Load Dw_DIM_CONSOL_STRUCTURE.dtsx Dw_DIM_CONSOL_STRUCTURE
L - DM 3.1.168 Load Dm_DIM_CONSOL_STRUCTURE.dtsx Dm_DIM_CONSOL_STRUCTURE