Cube Dimension - Campaign

This cube represents the sales dimension campaign and is based on the IFS Applications dimension DIM_CAMPAIGN.

ATTRIBUTES

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

USED BY CUBE

Cube Name
SALES

ETL Information

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