How to Filter data in OBIEE 10g

Friends,  Today We will see how to Filter data in OBIEE.

It is very simple.

Please take a look at the screenshots given below.

We will use Standard SH Schema available in Oracle.

Open the SH Subject Area in Oracle Answers. You will have all tables available in your left hand pane.

Randomly select few columns as shown below and prepare the report.

Now click on the Results tab to view the data. As you can see it will return all rows from the tables.

Now lets check out how filter works. You will be able to see "Filter Icon on each column in Criteria tab.
Lets filter the data based on Cust_Gender column in the report. Click on the FIlter icon. You can see a pop up window like below.

If you want to see the distinct values that Cust_gender contains click on the "All Choices" Link.
Out of the options available select any one to filter the data as shown below.

The new filter you just created will be visible under "filters" section.

Now click on the Results tab to view data. As you can see below. results are now filters based on Cust_Gender value = 'F'. Result is shown for all 'F' Gender.

This is how Filters work in OBIEE. It is simple to use.

Thanks a lot for stopping by.

For any questions/queries, Please comment below.

see you soon with new topic.