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......
Scoring disabled. You must be logged in to score posts.