Full Outer Join ????

Hi,
I am having 2 tables A and B. I want to select 4 measure objects - 2 from table A and 2 from table B.
I want to create a full outer join between the 2 tables in the Universe.
I want to select the 2 measure objects from table A even if the keys do’ne exits in table B and vice-verse.
How can i implement a full outer join in the Universe?

Akshay


akshay :india: (BOB member since 2004-02-05)

Is it possible to set up your universe to do a UNION ALL in the report query?


scott copeland (BOB member since 2002-08-15)

Unless there are dimensions involved would’nt it make more sense to have seperate select statements for each table?


JohnH :uk: (BOB member since 2003-08-19)

Or just create two separate data providers (one for fact table A, another for fact table B).


Andreas :de: (BOB member since 2002-06-20)

Are any dimension tables involved?

Hi,
Ya even I am thinking of separating the dataproviders (queries). Waiting for some confirmations from the client.
Any other way to do it?
Akshay


akshay :india: (BOB member since 2004-02-05)

If you have ‘multiple sql statements for each measure’ checked in parameters it should generate two statements within one data provider.


JohnH :uk: (BOB member since 2003-08-19)