Skip to Content
avatar image
Former Member

Solving loops

Hi All,

I have a large universe. I made all the joins and everything seems fine. I am stuck at a loop and not sure how do I solve it. Not good at context so need a right way if this needs to solved by context.

five tables forming a loop: 1. Session joined to sample

2. Sample joined to Result

3. Result joined to A

4. A joined to  Exposure

5. Exposure joined to session

Initially I made an alias of A  as A2 and joined it to exposure and it resolved my loop. But in the report I pull fileds from table A, exposure and Result. So the values from A and Result return correct data but as I pull the filed from exposure in the report it gives duplicate results.(more than what is expected). So I assume there should be a join betwwen A and Exposure but it results in loop. How do I solve this so that these three tables are connected and gives right results. I am using fields from all 5 tables in the report. How will I solve it if I have to use context?

Thanks,

N

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 15, 2014 at 06:19 AM

    Hi,

    How many of them are Dimension Table , and Fact table  ?

    Solving Loops depends on Cardinality of Joins in tables .

    what is cardinality ?

    if you have set cardinality then what is suggested by  Detect Loops (Context Or Alias ) ?

    Please follow the links below for better understanding .

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2014 at 02:50 PM

    Hi try to create alias for Session table....

    Add comment
    10|10000 characters needed characters exceeded