If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Case statement Error in Cognso 10.2.1

Started by joms, 08 Dec 2014 10:21:27 PM

Previous topic - Next topic

joms

Hello All,
I have an issue with the report when I moved reports from cognos 10.2 to cognos 10.2.1 for below query,

CASE WHEN ([Country of Origin] in ('England', 'Northern Ireland', 'Scotland', 'Wales', 'United Kingdom')) THEN ('United Kingdom')
WHEN ([Country of Origin] in ('China (Excludes SARs and Taiwan Province)')) THEN ('China')
WHEN ([Country of Origin] in  ('Taiwan (Province of China)')) THEN ('Taiwan')
WHEN ([Country of Origin] in  ('Hong Kong (SAR of China)') ) THEN ('Hong Kong')
ELSE ([Country of Origin])
END


The error message is :
RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0004 Found an internal error on node 'V5Query'. xtab on relational style query should be handled by single query approach.

I tried to replace Case with decode and if..else statement but NO Success.The error remains same.

Is there is any other ways to rewrite this logic ?I really appreciate help guys!

Regards,
Jo