Level and Members (Browser Tab, Dimension Designer) (SSAS)
Use this pane to browse the members of the currently selected hierarchy and language. To select a hierarchy or language to browse, use the Hierarchy and Language options on the Toolbar pane. For more information about the Toolbar pane, see Toolbar (Browser Tab, Dimension Designer) (SSAS).
Writeback Mode
The functionality of this pane changes if writeback mode is enabled. The selected dimension must be write-enabled (in other words, the WriteEnabled property of the dimension must be set to true) and the dimension must be deployed to an Analysis Services instance in order to enable writeback mode.
To enable writeback mode, you can either select Writeback from the Toolbar pane, or right-click the Level and Members pane and select Writeback from the context menu.
If writeback mode is enabled, you can perform the following additional actions in the Level and Members pane:
| To do | Perform |
|---|---|
Create sibling and child members within the selected hierarchy. |
Right-click the selected member and select either Create Sibling, to create a sibling member, or Create Child, to create a child member, from the context menu. |
Move a selected member up or down the hierarchy. |
Either drag the selected member to the appropriate parent or child member, or click Increase Indent or Decrease Indent on the Toolbar pane to move the selected member up or down the levels of the hierarchy. |
Rename a selected member. |
Either right-click the selected member and select Rename, or click an already-selected member. |
Edit member property values |
Double-click the value in the selected member property for the selected member to edit the value. |
Options
| Button | Description |
|---|---|
Current level |
Displays the level to which the currently selected member in Tree belongs. |
Tree |
Displays the members of the currently selected hierarchy and language. If member properties are selected from the Member Properties option of the Toolbar pane, each member property is displayed as a column. If writeback mode is enabled, one column for each key column associated with the key attribute in the dimension is displayed. |
Context Menu
The following options are available in the context menu displayed by right-clicking any part of the Level and Members pane for the selected member:
Button
Description
Create sibling
Creates a new member at the same level as the selected member.
.gif "ms180304.note(en-US,SQL.90).gif")
Note:
This option is enabled only if a member at a level other than the (All) level is selected.
Note:
This option is displayed only if writeback mode is enabled.
Create child
Creates a new member at the next lower level as the selected member, as a child of the selected member.
Note:
This option is enabled only if a member at a level other than the lowest level is selected.
Note:
This option is displayed only if writeback mode is enabled.
Cut
Copies the selected members to the clipboard and removes them from the hierarchy.
Note:
This option is enabled only if a member other than the All member is selected.
Note:
This option is displayed only if writeback mode is enabled.
Paste
Pastes members previously removed using Cut immediately after the selected member.
Note:
This option is displayed only if writeback mode is enabled.
Delete
Removes the selected members from the hierarchy.
Note:
This option is enabled only if a member other than the All member is selected.
Note:
This option is displayed only if writeback mode is enabled.
Rename
Select to edit the name of the selected member.
Note:
This option is enabled only if a member other than the All member is selected.
Note:
This option is displayed only if writeback mode is enabled.
Filter Members
Displays the Filter Members dialog box to filter members displayed in Level and Members for the selected hierarchy. For more information about the Filter Members dialog box, see Filter Members Dialog Box (SSAS).
Expand All
Expands all members in Tree.
Note:
This option is enabled only if a member at a level other than the lowest level is selected.
Collapse All
Collapse all members in Tree.
Expand Member
Expand the selected member in Tree.
Collapse Member
Collapse the selected member in Tree.
Writeback
Select to enable writeback mode.
See Also
Reference
Toolbar (Browser Tab, Dimension Designer) (SSAS)
Concepts
Browser (Dimension Designer) (SSAS)