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

User Interface - Navigation tree - Hierarchies 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

Data warehouse > Hierarchies context menu
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

Data warehouse > Hierarchies > STAR.DIM_Employees context menu
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

Data warehouse > Hierarchies > STAR.DIM_Employees > Account Managers context menu
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

Data warehouse > Hierarchies > STAR.DIM_Employees > Account Managers > ReportsTo context menu
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.

Related topics