Bringing data from 2 different data sources

Question

Hi,

OBIEE  11.1.1.9.0

I have 2 different Oracle databases.  APS database has the Employees information and O&M has the facts.  I have created a physical join between "F1 CR ALL DETAILS" to "Employees" on EMPLOYEE_NUMBER being the key.  In BMM, I brought both D10 Employees and F1 CR ALL DETAILS in a single BMM and so also in the Subject Area.  I verified the joins came over in BMM.  However when I run the analysis in OBI, the Employees view does not expand.  The circle next to it just keeps spinning.  I have no issues querying F1 CR ALL DETAILS.  Is this the correct way to bring data from multiple data sources?

As always, thanks for your help and the guidance you all provide.

Community DW Integration · Answer

@Gianni Ceresa & @Thomas Dodds - Thank you both for confirming that it is supported & should work bringing data from 2 different data sources.  I just started all over again and was able to bring the data I wanted.  Not sure what is messed up with the RPD I was working in.  Appreciate the service you folks provide to OBIEE community.

So that I can close this topic, I will mark Gianni's reply as the correct answer as he responded first   Please no hard feelings Thomas _/\_

Community DW Integration · Answer

@Thomas Dodds thanks for your reply.

Like you suggested, first I was thinking about creating a MVIEW in the O&M database but wanted to give this a try as we have couple more disparate sources and thought it would be helpful.

Looks like from your & Gianni's reply, even if it works, wouldn't be a very efficient way to do it.

Community DW Integration · Answer

@Gianni Ceresa thanks for your reply.

I don't even get to select the columns and see what the query is.  When I click on the Employee view, the circle next to the folder icon keeps spinning and never opens for selecting the columns (screen shot below).

So right now I am not much concerned about the performance - I just want to see it work :-)

Thanks.