Dimension Builder Panel

How to:

Reference:

The Dimension Builder enables you to create logical views based on enterprise data (relational or legacy data sources) for multidimensional analysis without manually editing metadata. You can enable the Dimension Builder by selecting Dimension Builder from the Tools group.


Top of page

x
Procedure: How to Add a Parent/Child Hierarchy
  1. From the Metadata canvas, click the Modeling View tab.
  2. Click the Dimension Builder icon from the Tools group.

    The Dimension Builder opens.

  3. Click the Parent/Child Hierarchy icon from the Dimension Builder toolbar.

    The Mandatory Properties for Parent/Child Hierarchy dialog box opens.

  4. Select a field from the Field Tree and click Assign to assign a Unique ID for the hierarchy.
  5. Repeat step 4 for the Caption and Parent hierarchy properties.
  6. Click OK to close the Mandatory Properties for Parent/Child Hierarchy dialog box.

    The Mandatory Properties are added to the Dimension Builder.

  7. Use the right-click menu to rename the dimension, view properties, or view sample data for the dimension.

Top of page

x
Procedure: How to Delete a Dimension

To delete a dimension, right-click a dimension and select Delete, or click the Delete button from the Dimension Builder toolbar.


Top of page

x
Procedure: How to Add Levels to the Hierarchy

This process enables you to edit an existing Master File, add tables (for non-WebFOCUS Master Files), and create and modify dimensions.

  1. From the Synonym Editor, click the Modeling View tab.
  2. Select the Levels Hierarchy button from the Dimension Builder toolbar.

    A level is added to the hierarchy. Use the right-click menu to rename the dimension or keep the default name.

  3. Drag the selected fields from a segment into the Dimension Builder hierarchy folder.

    You may also drag the fields to and from other hierarchies using the Dimension Builder.


Top of page

x
Reference: Dimension Builder Panel Toolbar

You can access the following commands from the Dimension Builder toolbar.

Button

Definition

Adds a level hierarchy.

Enables you to create a parent/child hierarchy and assign mandatory properties for the hierarchy.

Delete

Deletes the selected item.

Enables you to view and refresh sample data for the selected field.

Enables you to edit a hierarchy.


WebFOCUS