Examples: Dimension hierarchies

The following two examples illustrate a basic dimension hierarchy that would be created in your datamart and then mapped into Unica Campaign.

Example: Age Dimension Hierarchy

Lowest level: (21-25), (26-30), (31-35), (36-45), (45-59), (60+)

Rollups: Young (18-35), Middle (35-59), Older (60+)

Example: Income Dimension Hierarchy

Lowest level: >$100,000, $80,000-$100,000, $60,000-$80,000, $40,000-$60,000

Rollups: High (> $100,000), Middle ($60,000-$100,000), Low (< $60,000) (> $100,000), ($60,000-$100,000), (< $60,000)