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


Please Help Members By Posting Answers For Below Questions

What is the difference between slice and dice and cross tab report?

838


What is Indexing? how did u implement indexing?

2005


What sort of existing documents should business analysts refer to when starting on a new project?

797


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2165


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10317


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4525


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4748


U r project in which stage in implementation?

2191


how many reports have u created ? explain a few.

1849


Explain difference between zabo and webi?

845


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

889


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

814


What is the difference in creating filters in designer and business objects?

795


Did you face any problems while creating reports? Name? Solutions?

3462


What task is 98% of the required work of a business analyst?

776