About dimension hierarchies and database tables
When you create a dimension hierarchy in Unica 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, followed by 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 |