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.
Tuesday, March 23, 2010
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment