COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: learnflower on 23 Dec 2011 03:49:10 AM

Title: circular dependency error
Post by: learnflower on 23 Dec 2011 03:49:10 AM
I have  query 3 which is a join between 2 queries Q1 and Q2 , I am getting error as " QFS-ERR-0137 Query reference to 'Query3' creates a circular dependency " while i validated .

Suggest me how to proceed further.

Title: Re: circular dependency error
Post by: Gyana.Sahoo on 23 Dec 2011 03:54:50 AM
can you please tell me what is the requirement ?
how you join these Query (cardinality) ?
Title: Re: circular dependency error
Post by: learnflower on 23 Dec 2011 03:58:37 AM
cardinality is 1:1
Title: Re: circular dependency error
Post by: Gyana.Sahoo on 23 Dec 2011 04:51:04 AM
i can't get you ...
Can you elabroate abt ur requirement.
Title: Re: circular dependency error
Post by: MFGF on 23 Dec 2011 04:51:37 AM
It sounds to me like Query 1 or Query 2 might be referring to something in Query 3, which is in turn based on Queries 1 and 2, which refer to something in Query 3, which is in turn based on Queries 1 and 2...

MF.