To map a hierarchical dimension to a Campaign dimension
*
The following instructions assume that a hierarchical dimension already exists in your data mart.
*
Since in almost all cases dimensions will be used to create cubes, you may want to create dimensions from a flowchart in the Sessions area of the application.
1.
Access the Dimension Hierarchies window from one of the following places:
*
In a flowchart in Edit mode, click the Admin icon and select Dimension Hierarchies.
*
On the Administrative Settings page, select Manage Dimension Hierarchies.
The Dimension Hierarchies window appears.
2.
Click New Dimension.
The Edit Dimension window appears.
3.
Enter the following information about the dimension you are creating:
*
Dimension Name
*
Description
*
The number of levels in the dimension (in most cases, this should correspond 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 checked (Campaign checks this option by default). Otherwise, you will receive an error when you use this dimension to create a cube, since the values in elements cannot overlap in a cube.
4.
Click Map Table.
The Edit Table Definition window appears.
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 Campaign Administrator's Guide.
*
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 have finished mapping the table for the dimension, the Edit Dimension window appears with the dimension information for the new dimension.
6.
Click OK.
The Dimensions Hierarchies window appears 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 recreated, click Save on the Dimension Hierarchies window.
Copyright IBM Corporation 2015. All Rights Reserved.