Model: Sales - Specifications for Dimension Table: CAMPAIGN

On this page you will find the specifications regarding the Model: Sales and Dimension Table: CAMPAIGN.

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

Attributes

Attribute Description (where applicable)
Campaign Descr Represents the Campaign Name
Assortment ID Assortment Code
Campaign State Status of Campaign. Planned, Active etc
Campaign Created Date Date Campaign was created
Campaign Approved Date Date Campaign was approved
Campaign Code Represents the Campaign Code
Campaign Built as CODE + ' - ' + DESCRIPTION

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
CAMPAIGN DIM_CAMPAIGN_BI DIM_CAMPAIGN On Line