Cube Dimension - Reporting Entity

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.

ATTRIBUTES

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

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

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