About dimension hierarchies and database tables

When you create a dimension hierarchy in Campaign, you map it to a table in a database or a flat file.

The table must contain columns for:

The dimension name

Each level in the dimension hierarchy

The raw SQL or IBM® EMM expression that defines the audience entities in the bin

The data source

For example, the Age dimension hierarchy has three levels. The first level is All ages, followed by the two levels shown in the two levels of the following list:

This dimension hierarchy is based on the following database table:

Dimension hierarchy database table
Dimension- Name	Dim1Name	Dim2Name	Dim3Name	Expression	Datasource
MemberAge	All Ages	Under 30	< 20 Years Old	age < 20	Your datamart
MemberAge	All Ages	Under 30	20 - 25 Years Old	age between 20 and 25	Your datamart
MemberAge	All Ages	Under 30	26 - 30 Years Old	age between 26 and 30	Your datamart
MemberAge	All Ages	30 - 50 Years	30 - 40 Years Old	age between 31 and 40	Your datamart
MemberAge	All Ages	30 - 50 Years	41 - 50 Years Old	age between 41 and 50	Your datamart
MemberAge	All Ages	Over 50	51 - 60 Years Old	age between 51 and 60	Your datamart
MemberAge	All Ages	Over 50	Over 60	age > 60	Your datamart