Skip to Content
0

ShortCut join

Sep 03, 2017 at 09:15 PM

24

avatar image
Former Member

short-cut-join.png

Can you guys advise me a better approach to resolving the loop.

I have table A,B,C,D

This is a Adhoc universe.

User will choose objects from Table A->B->D or A->C->D currently universe having loop for resolving this issue i have created two context path one is for A->B->D ("Context A")

and other one is for A->C->D ("Context B")

but the problem is when user creating the reports its always asking to choose context either ("Context A") or ("Context B").

Is there way to avoid to ask the context , when they use A->B->D the context should take "Context A"

When they use A->C->D the context should take "Context B"

short-cut-join.png (28.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Sep 04, 2017 at 09:36 AM
0

try with below if you haven't tried.

universe file..>parameterrs...>SQL...>check : multiple sql statements for each context

Share
10 |10000 characters needed characters left characters exceeded