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.
| 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 |
| Cube Name |
| SALES |
| 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 |