Cube Dimension - Supplier

This cube dimension represents supplier information and is based on the IFS Applications dimension DIM_SUPPLIER. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

ATTRIBUTES

Attribute Hierarchy Description
Corporate Form NO Defined as the description of corporate form (COMPORATE_FORM_DESC)
Country NO Defined as the description of the supplier country code (COUNTRY_DESC)
Supplier NO Key. Built as CODE + ' - ' + SUPPLIER_NAME
Supplier Code NO The dimension CODE, i.e. the supplier identity
Supplier Name NO The name of the supplier (SUPPLIER_NAME)

USED BY CUBE

Cube Name
MAINTENENCE
PROCUREMENT
SALES
SALES CONTRACT

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SUPPLIER_BI ENTEDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.038 Load IFSAppl_DIM_SUPPLIER_BI.dtsx IFSAppl_DIM_SUPPLIER_BI
T - DW 2.1.038 Load Dw_DIM_SUPPLIER.dtsx Dw_DIM_SUPPLIER
L - DM 3.1.038 Load Dm_DIM_SUPPLIER.dtsx Dm_DIM_SUPPLIER