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 |
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?
When we are going for Shortcut join and why.
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
what is casual dimension?
Aliases and Contexts Which once will give the better performence when resolve the loops?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
how can u find the granularity in fact table
in xir2 how to send reports to end user
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik
How can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?