Can a report be developed using free hand SQL(Sql Query) using a DB Link

645922

Hello All,

A report to be developed based on query in OBIEE dashboards

Select Query -----1
UNION
Select Query------2

First select query is coming from one database schema and second is coming from the other.

Is there any way to develop the report using free hand SQL based on a DB link?
Is there any feature to use Database link (DB link)?


Thank in Advance,

SMA

gerardnico

What you ask is the direct database request capabilities :
http://gerardnico.com/wiki/dat/obiee/presentation_service/obiee_direct_database_request

But you can also use the federated query capabilities of the repository to model a star schema with two star schema from two different data source.


Cheers
Nico

gerardnico

What you ask is the direct database request capabilities :
http://gerardnico.com/wiki/dat/obiee/presentation_service/obiee_direct_database_request

But you can also use the federated query capabilities of the repository to model a star schema with two star schema from two different data source.


Cheers
Nico

674896

Hi,

you can use the option "this source should be combined with other sources at this level" in your logical table source, and define your tables content at the same level.
this will generate an union all between these table during execution.

rgds

645922

Thank You Nico


Regards,
SMA

645922

Thank you friend


Regards,
SMA