SAP BW Select Top/Bottom

SAP BW enables you to limit the size and rank the query result set on the data source server.

  To limit and rank SAP BW members as part of the query:

  1. In Dimension Browser, make a member selection or advanced member selection.

    Your member selection is displayed in the Selection frame.

  2. Right-click a member selection in the Selection frame and select Select Top/Bottom.

    The Top/Bottom dialog box is displayed. The controls prompt you to indicate top or bottom, define criteria, and select a dimension member for ranking.

  3. Select Top or Bottom.

    You cannot select both, as when using Essbase.

  4. From the Using Function group, select Percent, Sum, or Count.

    You can select only one method for determining rank.

  5. Enter a value for the method.

    The Percent text area should be a value between one and a hundred. The Sum text area requires you to enter a threshold. All member values summed to and including the threshold are returned. The Count text area requires only an integer indicating how n top or bottom members to return.

  6. In Order By, select another cube dimension.

    Because all dimensions participate in every intersection, you are required to identify the intersection by which the selected dimension is ranked.

  7. Optional: Click Selection to display the dimension browser for the Order By dimension.

    The Dimension Browser dialog box is displayed. You can select a dimension member from the dimension by which to rank the selected dimension, and click OK.

  8. Click OK to finish your Top/Bottom definition and return to Dimension Browser.

  9. Click OK.