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