I am trying to create an analysis from two different subject areas. I am wondering if there is a way that i can do that. Before we had one subject area and the performance was terrible since it was huge data, so we split it into two cubes and created two subject areas. Now i am trying to create analysis based of those two subject areas. Please advise
Solution - You will have to use Union, Intersection or difference operations to combine results from two or more Subject areas. I believe this is the only way.
How to do ? - In the right side of Analysis window, you will see a small green color icon embedded within another small oval icon. Click on it and it will ask you to select the subject area of your choice.
Requirement/Criteria - You will need to make sure that number of columns selected and its data type are the same across the subject areas selected.
You can create a query across multiple subject areas.
1.Start by creating a normal Answers request in a single subject area.
2.In the subject areas pane there is an icon with a green plus on it ("Add / Remove Subject Areas")
3.Select the second subject area
4.Choose a common dimension from either subject area and measures from the relevant source
If you add dimensions that are particular to a subject area, then the measure that is not relevant will return null.
One thing to understand is that if your are imagining having two Subject Areas (SAs) displayed and then dragging columns from each into your Request without any preparation, then no, that can't be done. You would need to do a join in the BMM layer and expose the column from the second Subject Area in the presentation layer.
But if you indeed interested in UNION (or intersect) queries, then do this:
Build your first query in the first SA in the usual manner. Note the number of columns and the data types of each column.
Now at the bottom of the Criteria workspace, there is a button called "Combine with similar request." Click it.
Select your second SA. You will note that the outlines of the columns in your first query appear. This is to remind you that the number of columns in this second query must be the same as in the first. It also shows the data type of each column for the same reason.
Once you select your columns and your filters, click on result. (Oh, you will also need to decide what kind of combination you want -- click on the dropdown.) The result will be a new Request that has data from both SAs in the query and combined in the manner you select (union, intersect, etc.)
That should give you a start.
http://obiee101.blogspot.in/2010/08/obiee-combine-with-similar-request.html -- Read this link this is good one to understand with screen shots. -- OBIEE 10g
From the Criteria Pane of the Report Created from First Subject Area, look at the bottom of the page, you will see an option called combine request click combine request and from here you can select second subject area and build the report with the req columns