This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Error while registering Essbase Java Function

June 29 2012 at 12:29 AM
No score for this post
Ravi 
from IP address 173.206.86.187

I am trying to make percentile function work (for BSO cube) in Hyperion using JPTILE, a pre-built java based function (sources given below).

/**
* Register function percentile
*/
CREATE MACRO $1.'@JPTILE'(SINGLE, GROUP)
AS '@_JPTILE(@@1, @@SH1)'
SPEC '@JPTILE(percent,expList)'
COMMENT 'Computes the specified (percent) percentile of a data set (expList)';

CREATE FUNCTION $1.'@_JPTILE'
AS 'com.hyperion.essbase.calculator.Statistics.percentile(double,double [])';



I registered it with Essbase, however, I am getting error while registering it:
[Tue Jun 26 13:54:14 2012]Local/Sample2///Warning(1200490)
Wrong java method specification [com.hyperion.essbase.calculator.Statistics.percentile(double,double [])] (function [@_JPTILE]): [specified method not found]

[Tue Jun 26 13:54:14 2012]Local/Sample2///Info(1200450)
External [LOCAL] macro [@JPTILE] registered OK


Please could someone advise, me on the right way to register the function. Any help would be highly appreciated......

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Error while registering Essbase Java Function - Javier on Jun 29, 12:57 PM
  2.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.