Filters are used to restriction the consequences that are displayed whilst an evaluation is administered, so that the effects answer a specific question. Based on the filters, handiest those outcomes are shown that matches the standards passed within the filter circumstance.
Filters are carried out without delay to attribute and measure columns. Filters are carried out before the query is aggregated and affect the query and accordingly the resulting values for measures.
For instance, you have a listing of participants wherein the aggregate sums to a hundred. Over time, extra members meet the set filter out standards, which will increase the mixture sum to two hundred.
Following are the methods to create filters −
Create a Named Column Filter
Go to Oracle Business Intelligence homepage → New menu → Select filter out. The Select Subject Area conversation is displayed.
From the Select Subject Area dialog, select the subject region for which you want to create a filter out. The "Filter editor" is displayed from the "Subject Areas pane". Double-click on the column for that you need to create the clear out. New Filter conversation is displayed.
Create an Inline Filter
Either create an analysis or access an existing evaluation for which you need to create a clear out.
Click the Criteria tab → Locate the "Filters pane" → Click create a clear out for the cutting-edge difficulty location button. The evaluation selected columns are displayed within the cascading menu.
Select a column call from the menu or pick the More Columns option to get admission to the “Select Column conversation" from which you can select any column from the difficulty location.
Once you select a column, the "New Filter conversation" is displayed.