Forum Stats

  • 3,875,565 Users
  • 2,266,946 Discussions
  • 7,912,256 Comments

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
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
Tagged:

Best Answer

  • gerardnico
    gerardnico Member Posts: 1,465
    Answer ✓
    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

Answers

This discussion has been closed.