Filters are used to limit the consequences that are displayed whilst an evaluation is administered, in order that the results solution a selected question. Based at the filters, simplest those consequences are proven that suits the criteria passed inside the filter circumstance.
Filters are applied directly to characteristic and measure columns. Filters are applied before the query is aggregated and have an effect on the question and hence the resulting values for measures.
For instance, you have got a listing of members wherein the mixture sums to one hundred. Over time, more participants meet the set filter criteria, which will increase the combination sum to 2 hundred.
Following are the methods to create filters −
Create a Named Column Filter
Go to Oracle Business Intelligence homepage → New menu → Select clear out. The Select Subject Area conversation is displayed.
From the Select Subject Area dialog, pick the situation place for which you want to create a filter. The "Filter editor" is displayed from the "Subject Areas pane". Double-click on the column for which you want to create the filter out. New Filter conversation is displayed.
Create an Inline Filter
Either create an analysis or get entry to an existing analysis for that you want to create a filter.
Click the Criteria tab → Locate the "Filters pane" → Click create a filter out for the present day difficulty place button. The analysis selected columns are displayed in the cascading menu.
Select a column call from the menu or choose the More Columns option to get right of entry to the “Select Column conversation" from which you may choose any column from the issue place.
Once you pick out a column, the "New Filter dialog" is displayed.