Cube Dimension - Sales Region

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

ATTRIBUTES

Attribute Hierarchy Description
Sales Region NO Key. Built as CODE + ' - ' + DESCRIPTION (represented by the ETL column CODE_DESCRIPTION)
Sales Region Code NO Represents the CODE of the dimension, i.e. the sales region code
Sales Region Descr NO Represents the DESCRIPTION of the sales region code

USED BY CUBE

Cube Name
SALES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.030 Load IFSAppl_DIM_SALES_REGION_BI.dtsx IFSAppl_DIM_SALES_REGION_BI
T - DW 2.1.030 Load Dw_DIM_SALES_REGION.dtsx Dw_DIM_SALES_REGION
L - DM 3.1.030 Load Dm_DIM_SALES_REGION.dtsx Dm_DIM_SALES_REGION