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.
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 |
Cube Name |
GROUP CONSOLIDATION |
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 |