This cube dimension represents the Reporting Entity and is based on the IFS Applications dimension DIM_REPORTING_ENTITY. 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 structure has its own set of Reporting Entity values.
Attribute | Hierarchy | Description |
Currency | NO | Represents the Currency code of the Reporting Entity |
Reporting Company Code | NO | Represents the CODE of the Reporting Company connected to the Reporting Entity |
Reporting Entity Code | NO | Represents the CODE of the dimension, i.e. Reporting Entity Code value |
Reporting Entity Desc | NO | Represents the DESCRIPTION of the Reporting Entity |
Reporting Entity Code Desc | NO | Built as CODE + ' - ' + DESCRIPTION |
Reporting Entity Type | NO | Represents the Type of the Reporting Entity in the form af a code |
Cube Name |
GROUP CONSOLIDATION |
BI Access View | BI Component | Recommended Source Type |
DIM_REPORTING_ENTITY_BI | GROCDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.172 Load IFSAppl_DIM_REPORTING_ENTITY_BI.dtsx | IFSAppl_DIM_REPORTING_ENTITY_BI |
T - DW | 2.1.172 Load Dw_DIM_REPORTING_ENTITY.dtsx | Dw_DIM_REPORTING_ENTITY |
L - DM | 3.1.172 Load Dm_DIM_REPORTING_ENTITY.dtsx | Dm_DIM_REPORTING_ENTITY |