Sequence of joins in Webi (auto generated query)

building semantic layer
1

I am using Teradata and Business Objects version 12.5.2. My issue now is that I need to have the joins in my Webi report re-arranged in such a way that a certain inner join needs to come first then followed by an right outer join so that I’ll have the expected # of rows returned.

The current sequence is from a right outer join followed by the inner join and this results to extra unneeded rows.

Please advise on how I can rearrange the joins in Webi WITHOUT doing a custom SQL at the Webi level.

thank you!

chinky :philippines: (BOB member since 2010-10-12)

2

…its not the answer you are looking for, but a derived table would do it :blue:

Possible altering the order of the objects in the Results Objects or Condition panels might help - but I think that could be fairly random.

Nick Daniels :uk: (BOB member since 2002-08-15)