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
What is the difference between slice and dice and cross tab report?
What is Indexing? how did u implement indexing?
What sort of existing documents should business analysts refer to when starting on a new project?
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.
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?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
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
U r project in which stage in implementation?
how many reports have u created ? explain a few.
Explain difference between zabo and webi?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is the difference in creating filters in designer and business objects?
Did you face any problems while creating reports? Name? Solutions?
What task is 98% of the required work of a business analyst?