Figure D.E.24.1 - Advertising Campaign

Please identify the fact of interest and build the attribute tree. No attributes have to be pruned or grafted. Some attributes cannot be used for aggregation in a meaningful way. Those should be tagged as non-dimension attributes in the fact schema.

Then derive the fact schema from the tree by defining dimensions, fact attributes and hierarchies and build a glossary for the fact attributes.

Please include an additional fact attribute, the duration of the advertising campaign which may be aggregated using the "average" operator along all dimensions.

Figure D.E.24.2 - The attribute tree

Company, product, advertising agency and country are defined as dimensions, dimension month is introduced as a range of the date attribute. The attribute group is tagged as optional.

The attribute costs is selected as a fact attribute and an additional key figure duration is introduced. Attribute duration is non-additive along all dimensions

The customer behaviour of a country and the description of a product become non-dimension attributes.

Figure D.E.24.3 - The fact schema

costs = SUM(ADVERTISING CAMPAIGN.costs)

duration = AVG(ADVERTISING CAMPAIGN.duration)