This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,877 Users
  • 2,269,775 Discussions


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

Hello All,

A report to be developed based on query in OBIEE dashboards

Select Query -----1
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,


Best Answer

  • gerardnico
    gerardnico Business Intelligence Consultant NetherlandsMember Posts: 1,465
    Answer ✓
    What you ask is the direct database request capabilities :

    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.



This discussion has been closed.