how can we build one report from two data bases
Answer Posted / tarukhemu
Create report by taking 1st query from 1st universe. Then 'Add Query' and select 2nd Universe there. This will give you data from two different universes. This works even if the two universes are pointing to different database connections.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create Index to the table in the universe designer and how it improves the Query performence
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain what would you consider as your biggest achievement and why?
Explain when to use local filter and when to use global filter?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Did you face any problems while creating reports? Name? Solutions?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
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....
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
what is xcelsius architecture?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain how to schedule the report in b.o?
Can you please send me the migration related issues .