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


Please Help Members By Posting Answers For Below Questions

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

935


What is aggregate table and aggregate fact table ... Any examples of both?

614


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?

1779


Explain which versions are used in the bo dashboard work?

635


Explain about a tricky situation for which you found a very simple solution?

543






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?

558


Is there any other repository domains rather than universe, security, document?

601


What is the difference between business requirement document and use case document.

587


Explain in detail about type 2(scd),

598


Explain how to schedule the report in b.o?

567


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?

9882


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

1829


Can we Save (save as) WEBI Doc as DESKI?

7078


What is Indexing? how did u implement indexing?

1820


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?

1481