Setting Up Work with Dimension Selection Schema Based on Controls Use

Question

How to set up working with a dimension selection schema if data area uses controls?

Application Area

The regular report view mode enables the user to execute various operations with data using controls. If a control contains a large number of levels, use selection schemas to facilitate working with it.

Source Data

The Cube of Socio-Economic Indicators cube will be used to create a data area. Creation of this cube is described in the Example of Creating a Cube section.

Create a data area

The data area looks as follows:

Only the last level elements should be displayed in the data area sidehead.

Solution

Create and set up a selection schema for the Territories dimension.

Stage 1. Creating a Selection Schema

To create a selection schema:

  1. Open the Object navigator dialog box and select the Selection Schema context menu item for the Territories dictionary.

  2. In the Selection Schemas dialog box click the Add button and select the Select Level item in the drop-down list. The Select Level Elements item is added to the Order of Actions list:

  1. Select the added element and click the Edit button.

  2. In the Edit Primitive dialog box select the Deselects option in the drop-down list.

  3. Set the RF and FO checkboxes (next to names of the Territories dictionary top levels):

  1. Click the OK button to save primitive settings.

The Select Level Elements item in the Order of Actions list changes its name to Deselect Level Elements:

  1. To save the selection schema, click the Save As button. The standard Object Properties dialog box opens. Enter the selection schema name: "Deselect Top Level Elements" in the Name box.

  2. To save settings, click the OK button in the Object Properties dialog box and then click the OK button in the Selection Schemas dialog box.

The selection schema has been created. Now it is necessary to set up its operation.

Stage 2. Setting Up Selection Schema

Go to the Reports tool window:

  1. In the Dimensions area of the Data Sources and Data Slices panel click the button next to the Territories dimension.

  2. In the Dimension Parameters dialog box select the Deselect Top Level Elements item in the Selection Schema drop-down list:

  1. Click the OK button to save dimension parameters.

When these operations are executed, the data area looks as follows:

When any level is selected in the Territories control, the data area shows only the bottom level elements.

Thus, the dimension selection schema has been created and set up to make it easier to operate data using controls in the report view mode.

See also:

Questions and Answers | Selection Schemas | Selecting Data Sources and Working with Them | Adding Interactive Report Contents Controls