OBIEE 10g - Union Request (combine 2 or more requests together)

Friends,

Today we will take a look at the UNION request concept in OBIEE.

We all are familiar with UNION SQL in Database.

Like this

Select col1, col2 from table1

Union

Select col1, col2 from table2

To perform same kind of operation in OBIEE, we need to follow following steps.

We will use Standard "SH" Subject Area available in Oracle.

Create a sample request as shown below.

Here i am select Prod Category and amount columns with a filter Prod_category = 'Electronics'

Click on the Results tab to view data. Now we will create one more request and merge both results with the help of UNION based request.

As shown in the screenshot below, Click on the "Combine with similar Request" button. It allows you to add one more request to existing request (basically the UNION operation). Once you click on this button, it will give you all Subject Areas available. You need to pick any one based on your requirement. This clearly says that, this is the only option in OBIEE, from where you can create report based on 2 different subject areas.

Now click on the desired subject area. As shown below you will be give the place holders to put columns for your new (2nd request in UNION) request.

Ad columns from your left hand pane. apply appropriate filter.
and run the report.

As you can see below, the combined result of both the requests are shown on the dashboard.

Thank you for stopping by here.

For any questions/queries, please comment below

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.