Creating dimension hierarchies
After you define a dimension hierarchy in an external table or flat file, you can create dimension hierarchies in IBM® Campaign.
Before you can create a dimension hierarchy in IBM® Campaign, you or an IBM® consulting team must create the dimension hierarchy definition in a database table in your data mart or in a delimited or fixed-width flat file.
This is an operation external to Campaign.
The lowest level of the dimension hierarchy must use either raw SQL or a pure IBM® EMM expression (no custom macros, user variables, or derived fields) to define the individual audience ID membership for each bin.
1.
Follow these steps to create a dimension hierarchy in IBM® Campaign.
2.
Use one of these methods to open the Dimension Hierarchies window:
*
When editing a flowchart, open the Admin menu Tiny person, pencil, and circle with menu arrow icon and select Dimension Hierarchies.
*
From the Campaign Settings page, click Manage Dimension Hierarchies.
3.
In the Dimension Hierarchies window, click New Dimension.
4.
Enter the details for the new dimension hierarchy:
*
The Dimension Name
*
A Description
*
The Number of Levels in the dimension hierarchy. This should correspond to the hierarchical levels in the table to which you are mapping this dimension hierarchy.
*
If you will use this dimension hierarchy as the basis for a cube, ensure that Elements are Mutually Exclusive is checked (by default, this option is checked). Otherwise, you will receive an error when you use this dimension hierarchy to create a cube because the elements cannot overlap in a cube.
If you are creating a dimension hierarchy purely for use in selecting from a strategic segment, then it is permissible to disable this option and create overlapping definitions. It is recommended, however, that you creative non-overlapping bins so that dimension hierarchies you create can be freely used both for building cubes as well as with strategic segments.
5.
Click Map Table.
The Edit Table Definition window opens.
6.
To map your dimension hierarchy table to either a table in the database or a flat file containing the dimension hierarchy definition, follow the instructions in To map a base record table to an existing database table.
After you finish mapping your dimension hierarchy, you return to the Edit Dimension window, which now includes details for the new dimension hierarchy.
7.
Click OK.
You return to the Dimensions window.
8.
(Optional but recommended) You can store a dimension hierarchy for future use in a table catalog by clicking Save. If you store a dimension hierarchy you can retrieve it later for another use or share it with other users rather than recreating it.
Copyright IBM Corporation 2015. All Rights Reserved.