can u create report to connect oracle and sqlserver at a time?
- 2 Answers
- 6806 Views
- Zensar, I also Faced
- E-Mail Answers
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 |
How many universes can be created in a project?
Explain in detail about type 2(scd),
how to limit number of rows in a report in business objects using webi?
what is incompactabulity error in sap bo
what are the tables used in health care domain project and columns used in report?
Explain when we use aggregate awareness function in designer?
Is there any other repository domains rather than universe, security, document?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How to create Index to the table in the universe designer and how it improves the Query performence
Can anybody explain me the following Authodications? Enterprise,LDAP,Standalone,Windows AD and Windows NT ?
HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?
Teradata 
