0 Replies Latest reply on Oct 10, 2013 8:06 AM by thePandaKid

    hyperion request query Nvl

    thePandaKid

      Hi everyone,

       

      I'm a beginner in Hyperion Sys9 have a couple of questions that need some advices from you.

      Appreciate for the help and advices, so below are my questions.

       

      In my result i have added a computed item named as [EGGP]  with the script below

       

      Script:    Nvl ( Esp1, Esg 2)

       

      and my Esg2 is also and computed item which script is as below

       

      Script:     Concat ( Number1, Number2) + '.' +  Number3+ '.' +  Number4+ '.' +  Number5+ '.'

       

      I don't want to write it in the result while i wan to write it in the Request

      which i  added a new computed item in the Request with the script below:

       

      Script :  NVL ( Esp1, CONCAT ( Number1,

      CONCAT ( '-',  CONCAT (Number2,

      CONCAT ( '-',  CONCAT ( Number3,

      CONCAT ( '.',  CONCAT (Number4,

      CONCAT ( '.',  CONCAT ( Number5,

      CONCAT ( '.',  '')))))))))))

       

      I did try to run solely on this script, it is working fine and i have compare with the Esg2, the result is identical

       

      CONCAT ( Number1,

      CONCAT ( '-',  CONCAT (Number2,

      CONCAT ( '-',  CONCAT ( Number3,

      CONCAT ( '.',  CONCAT (Number4,

      CONCAT ( '.',  CONCAT ( Number5,

      CONCAT ( '.',  '')))))))))))

       

       

       

      But once i combine into the Nvl it gave me the error as below:

       

      Server Error [1012]: SQL API: [SQLFetchScroll], SQL RETURN: [-1], SQL STATE: [22018], SQL NATIVE

      ERROR: [1722], SQL MESSAGE: [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01722: invalid number]

       

       

      Not really sure what trigger this. Kindly hope that anyone could please provide me some advices.

       

      Thanks.