Filtering Data

Cloud data source types: Oracle Analytics Cloud - Essbase

On-premise data source types: Oracle Essbase

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:

  1. In the Query Designer report worksheet, select a dimension.
  2. From the Essbase ribbon, select Query and then Data Filter.
  3. From Data Filter, under Count, select Top or Bottom and specify a number.
  4. Under Set, click ellipsis button.
  5. From Member Selection, select a row member for ranking, and click OK to return to Data Filter.
  6. Under Value, click ellipsis button
  7. From Member Selection, select a column member to run the ranking against, and click OK to return to the Data Filter dialog box.
  8. 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.

  9. Click Apply Query to display query results.