Editing dimension hierarchies

You can change a dimension hierarchy name, description, levels, and table mapping.

Procedure

  1. 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.
  2. You may need to load the dimension hierarchy that you want to edit.
  3. Select the dimension hierarchy that you want to edit.
  4. Click Edit.
  5. 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.
  6. To modify the table mapping, click Map table.

    The Edit Table Definition window opens.

  7. Follow the instructions in Mapping a base record table to an existing database table.
  8. After you map the dimension, you return to the Edit Dimension window, which now includes details for the new dimension hierarchy.
  9. Click OK.

    You return to the Dimensions window.

  10. (Optional but recommended) You can store your changes to any dimension hierarchies for future use in a table catalog by clicking Save.