Narrow report results by applying a View filter to the report. The View filter can include one or more filtering conditions that restrict the data displayed in the original report. Unlike the report filter, once the View filter is applied it does not retrieve data from the data source. Instead, a View filter restricts data based only on the report results already displayed on the screen.
Create a view filter by qualifying on any attribute or metric on a report. While attribute and metric qualifications both restrict the data displayed on the report, they are both created and defined in slightly different ways.
To filter data displayed on a report using the View filter:
Click the name of a report to execute it.
From the Tools menu, select View Filter. This displays a View panel in the report.
In the View filter panel, click Add Condition.
From the Filter
On drop-down list, select the object (attribute or metric)
on which you want to base the filter.
The following choices are available, depending on the type
of object selected.
For attribute-based filters, choose Qualify to set a specific value-based condition, or choose Select to choose attribute elements from a list.
Qualify - choose whether to filter on the attribute's description (DESC) or ID form. Then, select a comparison operator such as Greater than. Enter a value in the field on the right to finish defining the filter condition.
Select - choose In List or Not in List to include or exclude items that appear in the Selected list. Then choose elements from the Available list and add them to the Selected list.
Use the Search for field to search for a particular attribute element.
If you are filtering based on a metric, choose a comparison operator such as Greater than, and enter a value.
To compare the metric to another metric, click the Select Metric icon . Then select another metric to compare it to.
Click Apply to apply the new filter to the report.
Using correct and efficient search syntax
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices