Creating Retrieve Only Top/Bottom Definitions

  To create a Retrieve Only Top/Bottom definition:

1. Perform one:

   • Right-click a dimension member header and select Analysis Tools, then Retrieve Only Top/Bottom.

   • Right-click a dimension member header and select Analysis Tools. When the Analysis Tools Manager is displayed, select New Retrieve Only Top/Bottom.

   • Select Retrieve Only Top/Bottom from Data Layout Options.

   • In the last step of the Document Creation wizard, click Retrieve Only Top/Bottom.

     The Retrieve Only Top/Bottom dialog box is displayed.

2. Select the column to which the Retrieve Only Top/Bottom definition is applied from Select Column.

3. Limit the result set by selecting Top or Bottom and indicating the number of members in Value.

4. Sort the result set by selecting Ascending or Descending.

5. Optional: To remove all selections from the current definition and start over, select Clear.

6. Click OK.