The Edit Slice dialog box contains various features for listing Members in the Member/Hierarchy list box on the left, in order to easily send them to the Slice Content list box on the right. In a Dimension with few Members and a simple Hierarchy, the selection of Members to view in a Slice is straightforward. However, you may use complex Hierarchies and Dimensions with hundreds, or even thousands, of Members. In this case, the toolbar in the Edit Slice dialog box will help you search for Members at a certain hierarchical level or as they are defined in a relationship (such as parent/child or sibling) in a large Member list.
In the Edit Slice dialog box, on the left, you can toggle between two tabs: Member and Hierarchy.
The Members tab contains four controls that can be used to define the contents of the list box.
The Hierarchy tab contains six toolbar buttons that can be used to define the contents of the list box.
Icon Name |
Icon |
Description |
Expands the entire Dimension. |
||
Collapses the entire Dimension. |
||
Selects the deepest Member (in the Hierarchy) "beneath" a selected Member. |
||
Selects the "children" of a selected Member. |
||
Selects Members at the same level as the selected Member. |
||
Clears the current selection in the Hierarchy. |
The best way to understand these toolbar functions is to see them in action by playing with them in the Edit Slice dialog box. We recommend trying these buttons through the now familiar Month dimension. With the Month dimension expanded, select a Member in the Hierarchy and use the buttons on the toolbar to select other Members of the Hierarchy. In a large Dimension like Month, the buttons greatly simplify and accelerate selecting the Members you would like to see in your Slice.
Tip
The Dimension hierarchy is read-only in the Edit Slice dialog box,
which means a Hierarchy cannot be permanently altered while creating Slice
views. Setting up Hierarchies and editing their structure is a part of
database design. See the section: Modeling with PowerOLAP®, and
the topic Working with Dimensions, for more information on manipulating
Hierarchies in a permanent way.
Toolbar buttons
Let us assume at this point that you have established a list of Members in the left-hand list box, and now you want to move this list to the Slice Content list box on the right. You can use the drag-and-drop method you demonstrated previously, or you can use the toolbar buttons above the Slice Content list box, as explained below.
Move selected Members (highlighted) to the Slice Content box on the right
Again, with multiple Members, the buttons become more useful.
On the upper right side within the Edit Slice dialog box, the following Toolbar buttons enable you to quickly move Members from the Member/Hierarchy list box to the Slice Content list box on the right, and manipulate them, ultimately determining what appears in the Slice. Recall that the appearance of Members in the Slice Content box—and the order in which they appear—reflect how the Members will show up in the Slice when you click OK and exit from the Edit Slice dialog box.
Icon Name |
Icon |
Description |
Inserts
Member selection from the left (Member list box) below the selected
Member on the right (Slice Content list box). |
||
Inserts
all Members (from the left side) below the selected Member (on
the right side). |
||
All
Members on the right side are overwritten with Subset selection
on the left. |
||
Clears
all the Members in the Subset (on the right). |
||
Expands
an Aggregate member in the Slice Content list box. |
||
Set
the currently selected Member as the Page member (when working
in a Page dimension only). |
||
Lists
all the Alias and Property Groups for the Selected Dimension.
By default, it displays the 'Members' group which is a list of
all the Dimension members for the selected dimension arranged
accordingly as it appears on the Member list. This option allows
user to choose a display name for the Dimension members of the
current slice. |
||
Inverts
the selection in the Slice Content list box. |
||
Click on the Help button to bring up the the Help File for the Edit Slice dialog box. |
||
When you have modeled the Members for the Slice, click OK button to make edits effective and return to the Slice. |