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,
But once i combine into the Nvl it gave me the error as below:
Server Error : SQL API: [SQLFetchScroll], SQL RETURN: [-1], SQL STATE: , SQL NATIVE
ERROR: , 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.