cognoscognos-bicognos-11

RSV-VAL-0034 Failed to validate the variable 01. CRX-API-0016 The expression input string is empty: """" IBM


enter image description hereI am using Version 11.1.2fp2 IBM Cognos. I have many simple case statements that do not validate. The Report Runs. The report produces the expected output of data.

The error is RSV-VAL-0034 Failed to validate the variable 01. CRX-API-0016 The expression input string is empty: """".

CASE
  WHEN [Grant Agency TRACCD FRGBIL FOBTEXT with Budgets].[REAUTH_SDE_LAWS] IS MISSING
    THEN ''
  ELSE TRIM([Grant Agency TRACCD FRGBIL FOBTEXT with Budgets].[reauth_law_chapter])
END

Kindly, I have attached a screen shot with the Do you have any insights?


Solution

  • @dougp mentioned, an unprocessable variable from cognos is just what happened. Sometimes it might get hard to find the variable itself. One way of finding it is to get the xml definition and the search for the the declared variable. Reimporting the report won’t overwrite until you choose the saving location. Where to download xml definition