Analysis Services
Dimension Members Pane (Dimension Editor Data View)
Displays the dimension members in a tree format. Expand individual members to browse their descendants.
If the dimension is write-enabled and included in a processed cube, you can update the member hierarchy and member names in the dimension members pane. You can add, delete, and move members.
Caution Changes to a write-enabled dimension are recorded in the dimension table when you save the dimension. Thereafter, these changes cannot be undone except by editing the dimension and manually reversing the changes.
To move a member, drag it to its new parent or use the Move Selected Member buttons on the toolbar. To add, delete, move, or rename a member, right-click the member, and then click one of the following shortcut menu options.
| Shortcut menu option | Description |
|---|---|
| Delete | Displays the Delete Member dialog box so you can confirm the deletion of the selected member and select the disposition of its descendants. |
| Move Down | Moves the selected member (and its descendants) downward on its current level. The selected member becomes a child of its parent's following sibling. |
| Move Up | Moves the selected member (and its descendants) upward on its current level. The selected member becomes a child of its parent's preceding sibling. |
| Indent | Moves the selected member (and its descendants) down one level. The selected member's preceding sibling becomes its new parent. If the selected member does not have a preceding sibling, its following sibling becomes its new parent. |
| Outdent | Moves the selected member (and its descendants) up one level. The selected member's grandparent becomes its new parent. |
| Rename | Renames the selected member. |
| New Member - Sibling | Displays the Create Member dialog box so you can add a sibling of the selected member. |
| New Member - Child | Displays the Create Member dialog box so you can add a child of the selected member. |