Editing dimension hierarchies
You can change a dimension hierarchy name, description, levels, and table mapping.
Procedure
-
Use one of these methods to open the Dimension Hierarchies window:
- When editing a flowchart, open the Admin menu and select Dimension hierarchies.
- From the Campaign Settings page, click Manage dimension hierarchies.
- You may need to load the dimension hierarchy that you want to edit.
- Select the dimension hierarchy that you want to edit.
- Click Edit.
-
Modify the following details:
- The Dimension name
- A Description
- The Number of levels in the dimension hierarchy. This should correspond to the hierarchical levels in the database table to which you are mapping this dimension hierarchy.
- If you are using 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.
-
To modify the table mapping, click Map table.
The Edit Table Definition window opens.
- Follow the instructions in Mapping a base record table to an existing database table.
- After you map the dimension, you return to the Edit Dimension window, which now includes details for the new dimension hierarchy.
- Click OK.
You return to the Dimensions window.
- (Optional but recommended) You can store your changes to any dimension hierarchies for future use in a table catalog by clicking Save.