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