OBIEE Data Model from two different databases

3317169

Hi All,

I have a requirement like below:

There are two tables, Table1 resides in SQL Server database and Table2 is in Oracle database. I need to develop a report where the BI generated query should be like below

Select table1.colB,

           table1.colC

from Table 1 (SQL server db table)

where table1.colA in (select table2.colA from table2 (Oracle database table))

Could you kindly help me how the model should be inside RPD to meet the requirement

Thanks

[Deleted User]

Ltierally that query above? That's impossible. OBI can't magically write a single statement again st two different technology stacks.

You have to model this in the RPD in a model with conformed dimensions or two models which are completely stand-alone.

Then you can create answers requests which filter your first (SQL Server) data set "based on the results of another analysis" which is the one bringing information back from the Oracle table.

asim cholas

Try 12c Visual analyzer where you can blend data from different data sources.

Blending Data That You Added

[Deleted User]

How would he blend data with a subselect?

asim cholas

Just a doubt, cant he join it? with Col A of first table with column A of second table?

Select table1.colB,

           table1.colC

from Table 1 (SQL server db table)

where table1.colA in (select table2.colA from table2 (Oracle database table))

something like below?

select table1.colB,

table1.colC

from table1,table2

where table1.colA=table2.colA

[Deleted User]

My comment was geared towards the fact that his code is most likely just for demonstrative purposes and as soon as you propose the most obvious solution then comes "Oh but this doesn't work because my problem is actually XYZ" ;-)

So while it may work there's a good chance that in reality it won't. Also he's talking about a "report" which could mean anything from a A project or an analyses or an actual "report" as in a BIP report object but most people in here use all those terms like they mean the same thing

asim cholas

Most of the people will not come back and close the thread once they get answers.

[Deleted User]

true