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 Unica 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; below this are the two levels shown in the two levels of the following list:

Under 30

Under 20

20 to 25

26 to 30

30 to 50

30 to 40

41 to 50

Over 50

51 to 60

Over 60

This dimension hierarchy is based on the following 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