Universe Joins order

building semantic layer
1

Hi all,

I would like to know how can i make universe joining table with specific order.

For example, if I have table A,B,C
i want universe inner join A,C first then outer join B
However, now universe outer join A & B and inner join C

Does it hv any method to set the joining sequence? Thanks.

nicktyk (BOB member since 2010-04-22)

2

The order will depend upon how you create your joins on Universe. Try this simple exercise:

Drag three tables (A,B,C):

Case 1: Join A - B and then B - C. Export the Universe. Select objects from each class on Webi/Deski. Now look at the SQL generated. You will find:

Select <>
from A, B, C
where A.column = B.column and B.column = C.column

Case 2: Join B - C and then A - B. Export the Universe. Select objects from each class on Webi/Deski. Now look at the SQL generated. You will find:

Select <>
from A, B, C
where B.column = C.column and A.column = B.column

I tried this way back on BO XIR2 :slight_smile:

Rajat Sapru :us: (BOB member since 2008-08-28)

3

Do you mean that it is just listing joins in a particular order in the Oracle syntax (ie. joins in the WHERE clause), or is it nesting them in the FROM clause? Perhaps you could post the SQL.

slimdave :uk: (BOB member since 2002-09-10)