Filters are utilized to confine the outcomes that are shown when a program is executed, so that the outcomes result a specific query. In light of this filters, just those outcomes are demonstrated that matches the criteria go in the filters condition. This filters are connected specifically to trait and measure the columns. These are connected before the inquiry is accumulated and influence all the queries and along these lines the subsequent qualities for measures.

Filters can be accurately applied on a column for improving its productively. There are 2 types of create filters such as:

Create an inline filter

Either creating an test or get to a current investigation for which the user need to make a filter. Tap the Criteria tab → Locate the "Channels sheet" → Click make a channel for the present branch of knowledge catch. The test chose sections are shown in the falling menu. Select a column name from the menu or select the More Columns alternative to get to the “Select Column dialog" from which you can select any column from the subject area. Once you select a column, the "New Filter dialog" is displayed.

Create a named column filter

Go to Oracle Business Intelligence, and click on the homepage → New menu → Select channel. The Select Subject Area discourse is shown. From the Select Subject Area dialog, choose the subject area for which you want to create a filter. The "Filter editorial manager" is shown from the "Subject Areas pane". Double tap the column for which you want to create the filter. New Filter dialog is shown.

• Filters - Is used to confine the outcomes that are executed in the program.
• Column filters - Is used for improving the productively.