Cube Dimension - Company Customer

This cube represents the dimension company customer and is based on the IFS Applications dimension DIM_COMPANY_CUSTOMER.

ATTRIBUTES

Attribute Hierarchy Description
Company Customer NO company + ' - ' + code + ' - ' + customer_name as COMPANY_CODE_NAME
Company Customer Code NO Represents the specific Company Customer Code
Company Customer Company NO Represents the Company Customer Company
Company Customer Name NO Represents the Customer Name

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_COMPANY_CUSTOMER_BI INVODI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.101 Load IFSAppl_DIM_COMPANY_CUSTOMER_BI.dtsx IFSAppl_DIM_COMPANY_CUSTOMER_BI
T - DW 2.1.101 Load Dw_DIM_COMPANY_CUSTOMER.dtsx Dw_DIM_COMPANY_CUSTOMER
L - DM 3.1.101 Load Dm_DIM_COMPANY_CUSTOMER.dtsx Dm_DIM_COMPANY_CUSTOMER