Share via

Hierarchies (Dimension Structure Tab, Dimension Designer) (Analysis Services - Multidimensional Data)

  • Article

Use the Hierarchies pane to manage the hierarchies and levels for the currently selected dimension. For more information, see Create User-Defined Hierarchies.

You can use the Hierarchies pane to do the following procedures:

  • Create a new hierarchy by dragging an attribute from the Attributes pane to the Hierarchies pane.

  • Show or hide member properties for all the levels in the hierarchy by clicking the arrow next to the hierarchy name.

  • Show or hide attribute relationships by clicking the arrow next to the level name.

To display the Hierarchies pane

  1. In SQL Server Data Tools (SSDT), open the Analysis Services project, and then open the dimension that you want.

  2. If not selected, click the Dimension Structure tab.

Options

Hierarchies
Displays the currently created hierarchies. Within each hierarchy are the attributes that make up the levels of the hierarchy. Attribute relationships are also shown but they are read-only.

See Also

Dimension Structure (Dimension Designer) (Analysis Services - Multidimensional Data)
Attributes (Dimension Structure Tab, Dimension Designer) (Analysis Services - Multidimensional Data)
Data Source View (Dimension Structure Tab, Dimension Designer) (Analysis Services - Multidimensional Data)
Toolbar (Dimension Structure Tab, Dimension Designer) (Analysis Services - Multidimensional Data)