Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Can a report be developed using free hand SQL(Sql Query) using a DB Link

645922
Member Posts: 85
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
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
-
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
-
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 -
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 -
Thank You Nico
Regards,
SMA -
Thank you friend
Regards,
SMA
This discussion has been closed.