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:

Table 1. 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