Online Documentation for SQL Manager for Oracle
Adding dimension hierarchy
The Add Dimension Hierarchy dialog allows you to define a linear hierarchy of levels in the dimension. Each hierarchy forms a chain of parent-child relationships among the existing levels in the dimension. Hierarchies in a dimension are independent of each other.
Specify the name of the hierarchy. This name must be unique in the dimension.
Specify the name of a level that has a n:1 relationship with a parent level:
- select a child level in the Level as Child list;
- select the corresponding parent level in the Level as Parent list;
- click the Add button to set relationship between the selected levels;
- the pair of levels appears in the list below;
- repeat the operation for all the necessary levels.
To remove a relationship, select the pair of levels in the list below and press the Remove button.
Here you can specify an inner join relationship for a dimension whose columns are contained in multiple tables. Setting this relationship is required and permitted only when the columns specified in the hierarchy are not all in the same table.
Table schema / Table name
Use the drop-down lists to select the schema and the table to select columns for the join relationship.
Level to reference
Use the drop-down list to specify the name of a parent level.
To select a column, you need to move it from the Available Columns list to the Selected Columns list. Use the buttons or drag-and-drop operations to move the columns from one list to another.
Specify one or more columns that are join-compatible with columns in the parent level and press the Add button. To remove a column, select it in the Join key column(s) list and press the Remove button.