Filtering data limits the amount of data returned to a specified top or bottom criterion. Top or bottom ranking enables you to view, for example, the top 10 products in sales for a given region.
To filter data:
In the Query Designer report worksheet, select a dimension.
From the Essbase ribbon, select Query and then Data Filter.
From Data Filter, under Count, select Top or Bottom and specify a number.
Under Set, click .
From Member Selection, select a row member for ranking, and click OK to return to Data Filter.
Under Value, click
From Member Selection, select a column member to run the ranking against, and click OK to return to the Data Filter dialog box.
Click OK.
An MDX query in the form TopCount( { [Qtr3] }, 10, [Measures].[Profit]), that represents your data filtering settings is inserted into the grid. The example returns the top 10 most profitable products in quarter 3.