This parameter type is used to add more slicing capabilities to the views on the workboard.

You may want to use this capability especially when there are two views (or more) on the workboard, each based on a different data cube. Since the Slicers Pane can contain measures only from one data source, you will need to use the Dimension Members option to place the measures of the other view in the navigation component so that they can be selected for slicing that view.

The Dimension Members option also allows you to synchronize all the views in a workboard with the same dimension slicing. Once you use the Dimension Members option to place a dimension in the navigation component, selecting the dimension in the navigation component will slice all the views on the workboard that contain that same dimension.

The Dimension Members option provides slicing capability with different types of visualization. For example, you can define slicer selection from a dropdown list or an option button, or a slider.

After selecting Dimension Members, use the fields of this option as described below:

View

Choose the view from which you want to retrieve the dimension.

Based On

This dropdown will list the dimensions of the view you selected. Choose the relevant dimension. To define a slicer for the measures of the view, choose Measures.

Name

Enter a name for the parameter.

Title

The name that will appear as the title of the parameter in the navigation component. Use # as a placeholder for the selected value.

Show

Choose All Members to show all of the members of the selected dimension in the slicer.

To show specific members, choose Selected Members. In the dialog box that displays, click on a member in the All Members panel and click the arrow to move it to the Selected panel, or just double-click a member.

To deselect members in the Selected panel, double-click them. They will move back to the All Members panel.

To search for a member, click Search , type in the search text and click the filter  button (or press Enter).

Clicking the Select button opens the Select Members dialog box for making further selections or deselections.

Selection Type

Specify the type of selection allowed for this parameter:

·Single: A single member can be selected for slicing.

·Multiple: Several members can be selected for slicing using Ctrl-click or Shift-click.

·Range: A range of members (from-to) can be selected for slicing. Enter the From member and the To member.

See Use Case Examples.

Initial Value

Click on this field and choose the member that should be the initial selection for the parameter.

You can also define an initial value using MDX. Click the MDX Value tab and enter the MDX statements in the editing box. Click OK.

Apply To

Slicing by the slicer you are defining can affect the selected view, other views on the workboard, or all the relevant views (default) on the workboard. Choose the desired option. Choosing None means no slicing will be performed.

Once the Dimension Members parameter is defined, the dimension on which it is based is removed from the Slicers of the view to which the parameter is connected. If the parameter is applied to all views, it is removed from the slicers of the workboard. If there are several views on the workboard and the dimension of the parameter exists only in some, the dimension will remain in the Slicers.

Visualization

Specify the type of control to be used for selection: Selection Group, Selection Group (buttons), Drop Down, List, Slider. Note that when All Members is selected in the Show field, the only Visualization option is Tree Drop Down.

The following is an example for List:

When the visualization is Selection Group, Selection Group (buttons) or Slider, the Advanced Visualization  button is enabled for additional definitions.

In Max Buttons, enter the maximum number of buttons to show (for option buttons). In Layout, choose how the buttons should be arranged.

Advanced

Click the  button to open the Advanced window.

In Applies to, select Slicer if the navigation should perform only slicing, and Slicer & Grid if it should perform the slicing together with member selection in the grid (if the dimension is in the grid).

After selecting Slicer & Grid, choose the way member selection should apply in the grid:

§Members: regular member selection with no drill down capability on members.

§Members + drill down: member selection with drill down capability on members.

§Members + parents + allow drill: member selection, showing parent level, and with drill down capability.

§Members - flat layout: member selection, in flat layout.

§Children: member selection, showing only children level.

§Custom MDX: choose this option to define the member selection via MDX. Enter the MDX statements in the editing box. Click OK.

Use Case Examples

Example 1: From-To Period - Define a From-To parameter for slicing a view by time dimension members

Define a parameter with

Definition of second parameter:

The result that displays in the navigation component:

Example 2: Stores - Define a parameter for slicing a view by Store dimension members

Definition of parameter:

The result that displays in the navigation component:

Opening the dropdown displays the tree of stores to select from.