Hierarchies
Overview
The Hierarchies navigation tree branch opens hierarchy definitions for data mart structures.
Function
Use the branch or toolbar command to open the hierarchy list.
The list shows schema, table, hierarchy name, clustered setting, and actions for creating or deleting hierarchy rows.
Access
Open the Hierarchies branch from the navigation tree or use the Data mart toolbar tab.
How to access
Navigation tree
Hierarchies -> List hierarchies.
Toolbar
Data mart -> Hierarchies.
Diagram
Not opened directly from the diagram.
Visual element
Hierarchies navigation branch and list
Screen overview
Context menus access - Hierarchies - Where I can find it
The context menu examples below use the captured Data warehouse > Hierarchies navigation tree branch and show the Hierarchies branch, a table node, a hierarchy node, and a hierarchy-column node.
A.1) Hierarchies
| ID | Command | Description |
|---|---|---|
| 1 | Refresh | Reloads the Hierarchies branch. |
| 2 | List hierarchies | Opens the hierarchy list. |
| 3 | Add hierarchy | Creates a hierarchy from the selected context. |
| 4 | List scripts | Lists scripts available for the selected context. |
| 5 | Add script | Adds a script to the selected context. |
| 6 | Run script | Runs a script for the selected context. |
A.2) Hierarchies > STAR.DIM_Employees
| ID | Command | Description |
|---|---|---|
| 1 | Refresh | Reloads the selected table node. |
| 2 | List hierarchies | Opens the hierarchy list for the selected table. |
| 3 | Add hierarchy | Creates a hierarchy for the selected table. |
| 4 | List scripts | Lists scripts available for the selected table. |
| 5 | Add script | Adds a script to the selected table context. |
| 6 | Run script | Runs a script for the selected table context. |
A.3) Hierarchies > STAR.DIM_Employees > Account Managers
| ID | Command | Description |
|---|---|---|
| 1 | Refresh | Reloads the selected hierarchy node. |
| 2 | Edit hierarchy | Opens the selected hierarchy for editing. |
| 3 | Delete hierarchy | Deletes the selected hierarchy. |
| 4 | List scripts | Lists scripts available for the selected hierarchy. |
| 5 | Add script | Adds a script to the selected hierarchy. |
| 6 | Run script | Runs a script for the selected hierarchy. |
A.4) Hierarchies > STAR.DIM_Employees > Account Managers > ReportsTo
| ID | Command | Description |
|---|---|---|
| 1 | Edit hierarchy columns | Opens the hierarchy-column configuration for the selected column. |
| 2 | List scripts | Lists scripts available for the selected hierarchy column. |
| 3 | Add script | Adds a script to the selected hierarchy column. |
| 4 | Run script | Runs a script for the selected hierarchy column. |
