Share via


Hierarchies and Levels (Dimension Structure Tab, Dimension Designer) (SSAS)

Use the Hierarchies and Levels pane to manage the hierarchies and levels for the currently selected dimension. Drag columns or attributes into an existing hierarchy to add a new level to that hierarchy. Drag columns or attributes onto the Hierarchies and Levels design surface to create a new hierarchy.

After a hierarchy is created, you can add levels by dragging additional columns from the Data Source View pane or attributes from the Attributes pane into the hierarchy, or remove levels by dragging existing levels out of the hierarchy. To reorder levels within the hierarchy, drag the selected level to a different position within the hierarchy.

To display member properties for a level, click the down arrow next to the level name in the Hierarchies and Levels pane. To display member properties for all of the levels in the hierarchy, click the down arrow next to the hierarchy name. After the member properties are displayed, you can drag a column from the Data Source View pane or an attribute from the Attributes pane under a specific level to add a new member property to the attribute used to define the level, or drag existing member properties out of the hierarchy to remove a specific member property. To hide member properties for a level or for the hierarchy, click the up arrow next to the level name or hierarchy name, respectively.

Note

Member properties are associated with the attributes used to create a level, not with the level itself. Removing a member property from a level in a given hierarchy removes that association for that attribute. Any level based on that attribute in all other hierarchies for that dimension also loses that member property.

Options

  • Hierarchies and Levels
    Displays the currently created hierarchies. Within each hierarchy are the attributes that make up the levels of the hierarchy and, if applicable, the member properties associated with each level.

See Also

Reference

Dimension Structure (Dimension Designer) (SSAS)
Attributes (Dimension Structure Tab, Dimension Designer) (SSAS)
Data Source View (Dimension Structure Tab, Dimension Designer) (SSAS)
Toolbar (Dimension Structure Tab, Dimension Designer) (SSAS)

Help and Information

Getting SQL Server 2005 Assistance