CUBE DIMENSION - SALES PERSON

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

ATTRIBUTES

Attribute Hierarchy Description
Sales Person NO Key. Built as CODE + ' - ' + NAME
Sales Person Code NO Represents the CODE of the dimension, i.e. the sales person identity
Sales Person Name NO Represents the NAME of the sales person

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
DIM_SALES_PERSON_BI ORDEDI On Line

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.029 Load IFSAppl_DIM_SALES_PERSON_BI.dtsx IFSAppl_DIM_SALES_PERSON_BI
T - DW 2.1.029 Load Dw_DIM_SALES_PERSON.dtsx Dw_DIM_SALES_PERSON
L - DM 3.1.029 Load Dm_DIM_SALES_PERSON.dtsx Dm_DIM_SALES_PERSON