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

search case works, simple case doesn't

Started by hespora, Yesterday at 04:41:22 AM

Previous topic - Next topic

hespora

Cognos 10.2.2 on Oracle...

in a query, i'm inserting a simple mapping:
case
  when [dimension] = 'value' then 'blah'
  else 'blub'
end

That one works fine. Replacing the syntax with a simple case however:
case [dimension]
  when 'value' then 'blah'
  else 'blub'
end

will fail to run and yield an ORA-12704 character set mismatch. My [dimension] on the db is of type NVARCHAR; the only thing I can think of here is that search case and simple case use different data types for interpreting  the literals - is that what is happening?