In this section: |
Synonyms can be modified to support Online Analytical Processing (OLAP). The Synonym Editor provides tools to create OLAP hierarchies and dimensions. OLAP enables you to drill down or roll up on hierarchical data, pivot fields from columns to rows (or vice versa), and slice-and-dice information by filtering or querying data sources based on specified criteria thresholds.
You OLAP-enable the Master File by using the Synonym Editor to create dimension(s) at the field level and associate fields with each dimension.
Note: OLAP is a reporting facility. It is not relevant to data maintenance projects.
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. The Dimension Builder works with relational and FOCUS data sources. You can enable the Dimension Builder by selecting Dimension Builder from the toolbar or the Tools menu.
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-FOCUS 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.
The dimension is saved and stored in the Master File.
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 |