Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

645922Aug 14 2009 — edited Aug 14 2009
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
This post has been answered by gerardnico on Aug 14 2009
Jump to Answer

Comments

Dude!

I installed the Virtualbox guest additions in beta 8 recently, but there wasn't any need for kernel-headers or kernel-dev, etc. If I remember correctly, I simply choose Insert Guest Additions from the VM Devices menu and entered the root password. After the next restart I was able set screen resolutions. Did you try without installing kernel-headers?

3025127

Just downloaded the CD today https://www.oracle.com/technetwork/server-storage/linux/downloads/linux-beta-4409163.html . Workstation 8 has kernel-headers installed by default. Might be kernel-devel might be not required. I just added it just in case. Surely it's failing that missing package elfutils-libelf-devel. I was able to proceed only after installing elfutils-libelf-devel manually.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 11 2009
Added on Aug 14 2009
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
4 comments
1,642 views