1 Reply Latest reply: Feb 21, 2013 8:31 AM by Srini VEERAVALLI RSS

    Floating Error

    970365
      Hi
      I am using obiee11g in linux box.
      I have one report in 11g in that report one column formula like

      "CASE WHEN '@{var_EffType}' = 'Overall Efficiency' AND '@{var_CapType}' = 'What-If Situation' THEN CASE WHEN CAST('@{var_WI_Eff}' AS FLOAT) >= 0 THEN CAST('@{var_WI_Eff}' AS FLOAT) ELSE "

      taht report i put into dashboard when i select my prompt it return error like

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 9 expression on row count -1 failed. [nQSError: 46045] Cannot convert string () to floating point data. (HY000)


      bUT same report it working fine in 10g.After migration only problem.
      Could you please let me know how can i fix this issue.

      Thanks
      Gram.
        • 1. Re: Floating Error
          Srini VEERAVALLI
          Not sure why, the case stmt is not complete

          Since you are checking >0 I dont think its required to convert to float and to narrow down to the issue I would suggest cast to int and do not cast it after THEN.

          Try this

          CASE WHEN '@{var_EffType}' = 'Overall Efficiency' AND '@{var_CapType}' = 'What-If Situation' THEN
          CASE WHEN CAST('@{var_WI_Eff}' AS int) >= 0 THEN '@{var_WI_Eff}' ELSE NULL end end

          OR

          CASE WHEN '@{var_EffType}' = 'Overall Efficiency' AND '@{var_CapType}' = 'What-If Situation' and CAST('@{var_WI_Eff}' AS int) >= 0 THEN '@{var_WI_Eff}' ELSE NULL end

          If helps mark