Creating dimension hierarchies
To use dimensions in Unica Campaign, you must do the following:
- Define and create a hierarchical dimension in a table or delimited flat file in your data mart
- Map this hierarchical dimension table or flat file to a dimension in Unica Campaign
Note: A hierarchical dimension is created in the data mart either by the Unica Campaign system administrator or by members of your
consulting team, and is an operation
external to Unica Campaign. Also note that the
lowest level of the hierarchical dimension must use either raw SQL or a pure Expression (no custom macros, strategic segments,
or derived fields) to define the individual elements.
When this hierarchical dimension is then mapped into Unica Campaign, Unica Campaign executes this code to perform the various roll-ups.