can u create report to connect oracle and sqlserver at a time?
Answer Posted / praveen
Yes we can create a single report on two different db's
Open the Rich client and create a query on the universe
connected to Oracle db and then click on new query option,
then select the 2nd universe which is connected to
Sqlserver, create the 2nd query and run the queries.
I hope this will help.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How to create Index to the table in the universe designer and how it improves the Query performence
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
any difficulitis have you phase while creating bo reports and how did u solve it
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
How many universes can be created in a project?
What Is Snow Flake Schema?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain in detail about type 2(scd),
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what is the difference between business requirement document and use case document.
how many reports have u created ? explain a few.
Explain what are the steps to do to use alerts in bo?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
When we use aggregate awareness function in designer?
Explain how we drill up week to month?