Applying a common filter on two universes...

building semantic layer
1

Hi all ,
I have two Oracle databases(same schema but different servers) out of which I need to create a report . The Data in the report would be the union of data from similar tables which are on different databases. We have checking the possibility of using two different universes and combining the two in the report . Also we have three filter conditions that has to applied on the data (union of data from the two databases ) , in this we encounter the issue of applying the filter on both the universe separately . Is it possible to apply a common filter on both the universes.

 Also kindly explain if it’s possible to  join the two universes into one single universe

thanking you in advance,
Sandeep Nair

sandeepjs (BOB member since 2010-03-23)

2

Doing a union of two queries coming from different universes may not be possible, neither having a common filter on both universes
You can only synchronize two queries in the report

Universes can be linked but it requires the connection to be identical.
what you might be asking is to merge/combine two universes, this will again be a manual exercise with changes to be done on DB side to merge both schemas
.

haider :es: (BOB member since 2005-07-18)

3

As a last resort you could try a DB link, performance won’t be that great. It is better off to follow Haiders advice, if you can.

Mak 1 :uk: (BOB member since 2005-01-06)

4

thanks a lot for the valuble help !!!

sandeepjs (BOB member since 2010-03-23)