0 Replies Latest reply: Nov 5, 2012 7:54 AM by kirannch RSS

    Issue in validating @To_Date function in Calc manager 11.1.1.3

    kirannch
      Hi All,

      I am trying to calculate a fact account using ToDate function in Calc Manager (Hyperion 11.1.1.3) for Planning project requirement.The script is getting executed successffully in Essbase but not getting validated in Calc Manager.Below is the sample codelet,

      (actual code involves further calculations)

      spendtime = @TODATE("dd-mm-yyyy" ,@CONCATENATE ("01-01-",@NAME(@CURRMBR("SYears"))));

      error is:
      Error in: Rule:Rule_time
      Validation error from planning server 'http://xyz:8300/HyperionPlanning/servlet/HspAppManagerServlet'.
      'Error:Unable to resolve UDA, attribute member or dimension member with value, name or type "dd-mm-yyyy" Rule Rule_time'

      I am unable to validate the simple @ToDate function,It seems that Calc Manager validator is interpreting "dd-mm-yyyy" as dimenion or member name instead of format.

      please suggest any workaround .

      Thanks,
      Kiran