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
  • 7,916,823 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 Business Intelligence Consultant NetherlandsMember 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.