Cube Dimension - Sales Promotion Deal

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

ATTRIBUTES

Attribute Hierarchy Description
Sales Promotion Deal NO Key. Built as COMPAIGN_ID + ' - ' + CODE + ' - ' + DESCRIPTION
Sales Promotion Deal Campain NO The parent key, campain identity (CAMPAIN_IDENTITY)
Sales Promotion Deal Code NO Represents the CODE of the dimension, i.e. the campain deal identity
Sales Promotion Deal Descr NO Represents the DESCRIPTION of the campain deal

USED BY CUBE

Cube Name
SALES

ETL Information

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

 

ETL Step File Name of SSIS Package Table Name
E - Stage 1.1.083 Load IFSAppl_SALES_PROMOTION_DEAL_BI.dtsx IFSAppl_SALES_PROMOTION_DEAL_BI
T - DW 2.1.083 Load Dw_SALES_PROMOTION_DEAL.dtsx Dw_SALES_PROMOTION_DEAL
L - DM 3.1.083 Load Dm_SALES_PROMOTION_DEAL.dtsx Dm_SALES_PROMOTION_DEAL