COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: Sudha on 13 Oct 2005 10:42:11 AM

Title: [Unsolved] Circular Ref. Error
Post by: Sudha on 13 Oct 2005 10:42:11 AM
QE-DEF-0149 Incorrect query specification. QE-DEF-0036 The expression for 'Xxxxxxx' containes a circular reference.

Just a breif
Xxxxxxx is a Calculated Field and contains a string value depending upon the 'Rank field output'

Condition for Cal. Field say Displayis
If Rank >5 then 'Top 5' else 'Others'

and I'm grouping by Display

whenever I drag and drop this Display (for using it in For condition) I get the above error.

Help really appreciated
Where i'm doing wrong did search KBase also nybody experienced this kind of error before help me.

Sudha
Title: Re: Circular Ref. Error
Post by: cognosguru on 13 Oct 2005 02:50:25 PM
Hello,

I just ran into this situation and the cause of Circular Reference was the following:

Because both of the details were named Tabular Model 1 it sees it in both places and thus "goes around in circles trying to figure out which one of Tabular Model 1 to get". 

In order to solve it, rename Tabular Model 1 to a unique descriptive name.  Then it works. 

Good luck.
Title: Re: Circular Ref. Error
Post by: Sudha on 17 Oct 2005 10:02:56 AM
Well my problem is not solved over that ..I'm running into lot of other issues on the Same Report.

But I still get this error.
Title: Re: Circular Ref. Error
Post by: sir_jeroen on 17 Oct 2005 12:15:18 PM
I'm gonna close it [Unsolved]