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 were the reports scheduled and how to resolve unexecuted documents?
Can we create universe with no cache??
What sort of existing documents should business analysts refer to when starting on a new project?
Can anybody tell me what are the tuning problems?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain what are the steps to be taken to schedule the report?
8. How much supervision have you typically received in your previous job?
Difference between zabo and webi?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is the difference between user and versatile user?
What is package in BO
can anybody tell me about complicated object you have created
What is a bo repository?
What are the steps to be taken to schedule the report?