Mapping a hierarchical dimension to a Campaign dimension
To map dimensions, you create the dimension in 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.
*
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.
1.
Open the Dimension Hierarchies window in one of these ways.
*
In a flowchart in Edit mode, click the Admin icon Tiny person, pencil, and circle, with menu arrow icon and select Dimension Hierarchies.
*
On the Administrative Settings page, select Manage Dimension Hierarchies.
The Dimension Hierarchies window opens.
2.
Click New Dimension.
The Edit Dimension window opens.
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 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 (Campaign checks this option 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 window 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 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 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 on the Dimension Hierarchies window.
Copyright IBM Corporation 2015. All Rights Reserved.