can u create report to connect oracle and sqlserver at a time?
- 2 Answers
- 6529 Views
- Zensar, I also Faced
- E-Mail Answers
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
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
how to create metric universe ?
When to use local filter and when to use global filter?
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 aggregate table and aggregate fact table ... Any examples of both?
Explain how to execute the plsql procedure from the report by clicking with mouse?
how get the grand total in master-detail report?
How to schedule the report in b.o?
Explain what task is 98% of the required work of a business analyst?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain what is the difference between slice and dice and cross tab report?
8. How much supervision have you typically received in your previous job?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is difference between custom hierarchy and report based hierarchy?
