COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: whatever890 on 09 Aug 2006 02:29:28 PM

Title: RS - CN Node
Post by: whatever890 on 09 Aug 2006 02:29:28 PM
Hi all,

I keep getting the following error when running a Report Studio report:

PCA-ERR-0062
The "cn" node is not expected to be a "value".

I usually get this when putting a filter in a crosstab...this time around I built a simple crosstab
Title: Re: RS - CN Node
Post by: whatever890 on 09 Aug 2006 02:32:47 PM
Ok, can you tell I'm a newbie here!! :-[

Anyway, I was trying to explain that I built a crosstab with 1 measure, totalled the measure and am now trying to filter out where [total(Claims Expense)]>0 on the summary filter.  Seems simple enough, huh???

TIA 
Title: Re: RS - CN Node
Post by: Fiala on 14 Nov 2006 09:02:03 AM
TIA,
Did you ever come up with a solution to this error?  I too am experiencing the same error on a crosstab.

SYF

Quote from: moonbaby870 on 09 Aug 2006 02:29:28 PM
Hi all,

I keep getting the following error when running a Report Studio report:

PCA-ERR-0062
The "cn" node is not expected to be a "value".

I usually get this when putting a filter in a crosstab...this time around I built a simple crosstab
Title: Re: RS - CN Node
Post by: workdan on 15 Nov 2006 09:09:54 AM
I've encountered this error as well when using a crosstab. It appears to be related to the presence of "total(Measure)" in your query. For me, at least, this has only happened when viewing tabular data for a query, not when viewing the report itself, so temporarily removing the total has gotten around the error.

I know this isn't a comprehensive solution, but hopefully it can point you in the right direction - the error does appear to involve the appearance of the total() function in the query.

Sorry I can't be of more assistance.

Dan