Having Problem with ShortCut joins.

[rohan77]

Hi ,

Shortcut joins are working in one universe and not working in another.
Lets say that I have 3 tables
Table A, Table B and Table C. We have the following joins
1. shortcut joins from Table A to Table B.
2. normal joins from Table A to Table C.

Now when we pull objects from Table A , B and C the shortcut join does not work in one universe hence giving a cartesian product and in the other universe it works absolutely fine.

So is there any property we need to set to enable this to work.
Also is this the right way to do in Universe Design or does the shortcut join works only between 2 tables and not more than 2.

Thanks and Regards
Rohan

 

[skrandel]

Do you have other shortcut joins defined in the query. The normal behavior of BO is to choose 1 and only shortcut join for the entire query.

What about contexts. Have you included the shortcut join in your context?

Steve Krandel
Symantec