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.
The Dimension Builder opens.
The Mandatory Properties for Parent/Child Hierarchy dialog box opens.
The Mandatory Properties are added to the Dimension Builder.
To delete a dimension, right-click a dimension and select Delete, or click the Delete button from the Dimension Builder toolbar.
This process enables you to edit an existing Master File, add tables (for non-WebFOCUS Master Files), and create and modify dimensions.
A level is added to the hierarchy. Use the right-click menu to rename the dimension or keep the default name.
You may also drag the fields to and from other hierarchies using the Dimension Builder.
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. |
|
Deletes the selected item. |
|
Enables you to view and refresh sample data for the selected field. |
|
Enables you to edit a hierarchy. |
WebFOCUS |