Mapping a hierarchical dimension to a Unica Campaign dimension

To map dimensions, you create a dimension in Unica Campaign and then specify the file or table that contains the hierarchical dimension. The hierarchical dimension must exist in your data mart before you can complete this task.

Before you begin

Note: Since in almost all cases dimensions are used to create cubes, you may want to create dimensions from a flowchart in the Sessions area of the application.

Procedure

  1. Open the Dimension hierarchies dialog in one of these ways:
    • In a flowchart in Edit mode, open the Admin menu and select Dimension hierarchies.
    • On the Administrative settings page, select Manage dimension hierarchies.
  2. In the Dimension hierarchies dialog, click New dimension.

    The Edit dimension dialog opens.

  3. Enter the following information about the dimension that you are creating:
    • Dimension name.
    • Description.
    • Number of levels in the dimension. (In most cases, this number corresponds to the levels in the hierarchical dimension in the data mart to which you are mapping this dimension.)
    • If you are using this dimension as the basis for a cube, ensure that the Elements are mutually exclusive check box is selected (it is selected by default). Otherwise, when you use this dimension to create a cube an error results, since the values in elements cannot overlap in a cube.
  4. Click Map table.

    The Edit table definition dialog opens.

  5. Select one of the following options:
    • Map to existing file
    • Map to existing table in selected database

    Proceed with the steps for mapping a table. For details, see the Unica Campaign Administrator's Guide.

    Note: When mapping tables for dimension hierarchies, the field names "Level1_Name," "Level2_Name," etc. must exist in the table for mapping to succeed.

    When you finish mapping the table for the dimension, the Edit dimension window opens with the dimension information for the new dimension.

  6. Click OK.

    The Dimensions hierarchies window opens with the newly mapped dimension visible.

  7. To store a dimension hierarchy so that it is available for future use and does not need to be re-created, click Save in the Dimension hierarchies dialog.