This cube represents the sales dimension campaign and is based on the IFS Applications dimension DIM_CAMPAIGN.
Attribute | Hierarchy | Description |
Campaign | NO | cast(cast(code as int) as nvarchar) + ' - ' + description as CODE_DESCRIPTION |
Campaign Code | NO | Represents the Campaign Code |
Campaign Descr | NO | Represents the Campaign Name |
Cube Name |
SALES |
BI Access View | BI Component | Recommended Source Type |
DIM_CAMPAIGN_BI | ORDEDI | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.1.102 Load IFSAppl_DIM_CAMPAIGN_BI.dtsx | IFSAppl_DIM_CAMPAIGN_BI |
T - DW | 2.1.102 Load Dw_DIM_CAMPAIGN.dtsx | Dw_DIM_CAMPAIGN |
L - DM | 3.1.102 Load Dm_DIM_CAMPAIGN.dtsx | Dm_DIM_CAMPAIGN |