Error while registering Essbase Java FunctionJune 29 2012 at 12:29 AM
No score for this post
from IP address 22.214.171.124
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)'
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......
- Re: Error while registering Essbase Java Function - Javier on Jun 29, 2012, 12:57 PM