SAP BW enables you to limit the size of and rank query result sets. You select members and then define filtering definitions on the selections.
To limit and rank SAP BW members as part of the query:
In Dimension Browser, select a member.
The member is displayed in the Selection frame.
Right-click the member, and select Select Top/Bottom.
The Top/Bottom dialog box is displayed.
You cannot select both, as you can with Analytic Services.
From Using Function, select Percent, Sum, or Count.
You can determine rank by only one method.
In the text area, enter a value for the selected method.
For Percent, use a value between one and one hundred. For Sum, enter a threshold. All member values summed up to and including the threshold are returned. For Count, provide an integer, to indicate how many top or bottom members to return.
In Order By, select a dimension.
Because all dimensions participate in all intersections, you must identify the intersection by which the selected dimension is ranked.
Dimension Browser for the Order By dimension is displayed. You can select a member of the Order By dimension by which to rank the selected dimension.