CUBE DIMENSION - SALES DISTRICT

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

ATTRIBUTES

Attribute Hierarchy Description
Sales District NO Key. Built as CODE + ' - ' + DESCRIPTION
Sales District Code NO Represents the CODE of the dimension, i.e. the sales district code
Sales District Descr NO Represents the DESCRIPTION of the sales district code

USED BY CUBE

Cube Name
SALES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.027 Load IFSAppl_DIM_SALES_DISTRICT_BI.dtsx IFSAppl_DIM_SALES_DISTRICT_BI
T - DW 2.1.027 Load Dw_DIM_SALES_DISTRICT.dtsx Dw_DIM_SALES_DISTRICT
L - DM 3.1.027 Load Dm_DIM_SALES_DISTRICT.dtsx Dm_DIM_SALES_DISTRICT