Cube Dimension - Structure Node Sub Level

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

Sort Order of attributes Structure Node Sub Level 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
Currency Code NO Represents the ID of the corresponding Currency Code
Reporting Company Code NO Represents the ID of the corresponding Reporting Company
Reporting Company Code NO Represents the Name of the corresponding Reporting Company
Structure NO Structure ID
Structure Node Sube Level Code NO Represents the CODE of the dimension, i.e. Sub Level Code value
Structure Node Sub Level Desc NO Represents the DESCRIPTION of the Sub Level value
Structure Node Sub Level Code Desc NO Built as Sort Order+'-'+ CODE + ' - ' + DESCRIPTION
Structure - Code - Desc NO Built as STRUCTURE ID  + ' - ' +CODE + ' - ' + DESCRIPTION
Structure Node Sub Level Type NO Represents the type of the Structure Node Sub Level

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.170 Load IFSAppl_DIM_CONSOL_STRUCT_SUB_LEVEL_BI.dtsx IFSAppl_DIM_CONSOL_STRUCT_SUB_LEVEL_BI
T - DW 2.1.169 Load Dw_DIM_CONSOL_STRUCT_SUB_LEVEL.dtsx Dw_DIM_CONSOL_STRUCT_SUB_LEVEL
L - DM 3.1.169 Load Dm_DIM_CONSOL_STRUCT_SUB_LEVEL.dtsx Dm_DIM_CONSOL_STRUCT_SUB_LEVEL