Combining Databases

[funkmonsteruk]

I am currently using Business Objects to run reports from database but need to combine details from another database.

The two databases, although not linked in any way, do have common data (this is in the form of a bank sortcode) - is it possible to report on both of these databases at once. I'm guessing that two universes are required but am really not sure.

Can anybody help???????

 

[skrandel]

2 universes - 1 for each database

Read up on linking data providers.

In a nutshell, you'll write 2 queries and then link the common dimensions at the report level. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com