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