can u create report to connect oracle and sqlserver at a time?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gs2kumar@gmail.com
No We cannot connect to multiple databases at a time by
using single datasourse only we can create the report
| Is This Answer Correct ? | 1 Yes | 5 No |
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples
what is variable ?
how do we apply sql query on selected variables?
Can we configure two instances of CMS pointing to two different CMS system databases?
what is the difference b/w star and snowflack schema in dataware house?
Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?
What is the functional & architectural differences between business objects and web intelligence reports?
What are the security level used in BO?
Analysis in business objects?
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
Difference between Decode and Case?
8 Answers Polaris, TCS, Wipro,