Tuesday, March 23, 2010

-ve Numbers Weird Issue for ALL Static Choice in Value Prompt

You must have used a static ALL value in your prompts to handle the "1000 Values in the In Clause" in Oracle issue. Now if you had set the use value for this to be -9999 or any -ve number in order to set this to a value that will never be available in your table Cognos seems to be behaving weirdly.

It throws error RSV-VAL-004 Unable to find query information for XYZ. Change the case statement to a numeric value and the report validates perfectly.

Using -ve numbers seem to be causing weird issues.

No comments: