Cube Dimension - Reporting Company

This cube dimension is based on the COMPANY dimension and represents the company represented by a reporting entity. The dimension is based on the IFS Applications dimensions DIM_COMPANY_BASE and DIM_COMPANY. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Reporting Company NO Built as CODE || ' - ' || NAME || ' (' || CURRENCY_CODE || ')'
Reporting Company Code NO Represents the CODE of the dimension (company)
Reporting Company Code Name NO Name of the reporting company built as CODE || ' - ' || NAME
Reporting Company Country Code NO Represents the COUNTRY code of the reporting company
Reporting Company Currency NO Represents the CURRENCY_CODE of the reporting company
Reporting Company Name NO Represents the NAME of the reporting company

USED BY CUBE

Cube Name
GROUP CONSOLIDATION

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_COMPANY_BI ACCRDI On Line
DIM_COMPANY_BASE_BI ACCRDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.012 Load IFSAppl_DIM_COMPANY_BASE_BI.dtsx IFSAppl_DIM_COMPANY_BASE_BI
  1.1.012 Load IFSAppl_DIM_COMPANY_BI IFSAppl_DIM_COMPANY_BI
T - DW 2.1.012 Load Dw_DIM_COMPANY Dw_DIM_COMPANY
L - DM 3.1.012 Load Dm_DIM_COMPANY Dm_DIM_COMPANY