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

Explain the data types present in bo and what happens if we implement view in the designer and report?

555


How to generate the report from excel sheet?

578


Explain what are the steps to do to use alerts in bo?

602


What is report template in b.o?

578


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9415






in sap bi we have wad, then why we go for sap bo

2772


What is the dense rank?

667


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?

541


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1487


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1471


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

3256


how to create metric universe ?

1891


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1770


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

1611


Explain what are the steps to be taken to schedule the report?

631