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......