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

Adding dimension level


The Add Dimension Level dialog allows you to specify dimension level properties.

 

Dimension Editor - Adding dimension level

 

Level name

Specify the name of the level to be added.

 

Level column(s)

This group allows you to specify the column(s) in the level. You can specify up to 32 columns.

 

Table schema / Table name

Use the drop-down lists to select the schema and the table to select columns for the level.

 

To select a column, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the columns from one list to another.

 

Attribute column(s)

This group allows you to specify the columns that are uniquely determined by a hierarchy level. The columns in level must all come from the same table as the dependent columns.

To select a column, you need to move it from the Available list to the Selected list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the columns from one list to another.