Cube Dimension - Company

This cube dimension represents the financial companies and 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
Company NO Built as CODE || ' - ' || NAME || ' (' || CURRENCY_CODE || ')'
Company Code NO Represents the CODE of the dimension (company)
Company Code Name NO Name of the company built as CODE || ' - ' || NAME
Company Country Code NO Represents the COUNTRY code of the company
Company Currency NO Represents the CURRENCY_CODE of the company
Company Group NO Represents the COMPANY_GROUP of the company. Refer to Financial KPI Functionality. * Only implemented in the General Ledger Cube.
Company name NO Represents the NAME of the company

USED BY CUBE

Cube Name
GENERAL LEDGER
HUMAN RESOURCES
MAINTENENCE
MANUFACTURING
PROCUREMENT
PROJECT
SALES
SALES CONTRACT

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