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 DescrRepresents the Campaign Name
Assortment IDAssortment Code
Campaign StateStatus of Campaign. Planned, Active etc
Campaign Created DateDate Campaign was created
Campaign Approved DateDate Campaign was approved
Campaign CodeRepresents the Campaign Code
CampaignBuilt 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
CAMPAIGNDIM_CAMPAIGN_BIDIM_CAMPAIGNOn Line