Online Documentation for SQL Manager for Oracle

Creating/editing dimension

Use the Dimension tab of Dimension Editor to create/edit a dimension and specify its properties.

Name

Specify the name of the dimension to be created, or view the name of the dimension being edited. Note that the dimension name must be unique within its schema.

Schema

Use the drop-down list to specify the schema in which the dimension will be created.

Levels

A level defines dimension hierarchies and attributes. The list displays the existing levels as a grid with the following columns: Level Name, Level Columns, Attributes.

Right-click an item within the list to call the context menu allowing you to add a new level and specify its properties using the Add Dimension Level dialog or delete the selected level from the list.

Level management tools are also available through the Add level and Delete level buttons.

Hierarchies

The list displays the dimension hierarchies as a grid with the following columns: Hierarchy Name, Child Level, Parent Level, Joins.

Right-click an item within the list to call the context menu allowing you to add a new hierarchy and specify its properties using the Add Dimension Hierarchy dialog or delete the selected hierarchy from the list.

Hierarchy management tools are also available through the Add hierarchy and Delete hierarchy buttons.

To compile the object, use the corresponding Compile item of the Navigation bar or toolbar.