EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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.

 

Dimension Editor - Editing Dimension definition

 

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 btnAddItem and Delete level btnRemoveItem 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 btnAddItem and Delete hierarchy btnRemoveItem buttons.

 

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