Examples: Dimension hierarchies
The following two examples illustrate a basic dimension hierarchy that would be created in your datamart and then mapped into 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)