two universes with different database connections in the same application

[Former Member]

How to use two universes with different database connections in the same application?

[Former Member · Accepted solution]

Hi,

Is the application you are talking about Web Intelligence? If so you can create two or more queries in Web Intelligence and then merge the dimensions. You can only merge on a dimension not a detail object or measure.

Think of the merge as a join of the queries.

[Former Member]

Hi,

       1. You can create Multi-Souce enabled universe at BO IDT in BOBI 4.0. Which means you can connect to two different RDBMS on the same universe.

       2. But for past versions of BOE, you can use data federator to gain the same feature.

       3. Otherwise you can get the same affect at WEBI level by using the concept merge dimension.