Skip to Content

ShortCut join

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 04, 2017 at 09:36 AM

    try with below if you haven't tried.

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

    Add comment
    10|10000 characters needed characters exceeded