Forum Stats

  • 3,874,888 Users
  • 2,266,782 Discussions
  • 7,911,992 Comments

Discussions

Categories

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

645922
645922 Member Posts: 85
edited Aug 14, 2009 4:58AM in Business Intelligence Suite Enterprise Edition (OBIEE)
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:
· Share on TwitterShare on Facebook

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
    · Share on TwitterShare on Facebook

Answers

This discussion has been closed.