How to apply saved selections

A saved selected is a predefined selection of members for a dimension. It can be specified as members themselves, or as criteria for selecting members (e.g. last three months, top 10 cities based on shoe sales). You can apply saved selections to worksheets containing data from multidimensional (OLAP) data sources.

To apply a saved selection:

1. Display the worksheet that you want to analyze (for more information, see "How to open a Discoverer worksheet").

2. Select the Saved Selections link to display the saved selection tools above the worksheet.

   Discoverer updates the worksheet according to drilling options you specified.

3. Use the Dimension drop down list to select dimension whose members you want to update.

4. Use the Action drop down list to specify whether to replace the current set of dimension members with those in the saved selection, whether to add the members from the saved selection to the current members, whether to remove the members in the saved selection from the current selection, or whether to keep only the dimension members in the current selection that are also in the saved selection.

5. Use the Saved Selection list to specify the saved selection to apply.

6. Click Go to apply the saved selection.

   Discoverer updates the worksheet according to saved selections you have applied.