Hello All
I am attempting to develop an Essbase Custom Defined Function (CDF) that will take two parameters and execute a simple SQL query to return a double as the result. I've followed the instructions outlined in the Planning Administrators Guide and as far as I can tell everything should work as documented.
I have successfully unit tested my class/function in JDeveloper with the inputs and it queries the DB successfully and returns the expected results each time. I have performed the following steps:
1) Copied my .java file to the Essbase server and compiled it to a JAR file using the SDK on the server - this was to avoid any version issues between my development (client) and server machines
2) Copied the JAR file to the following location:
./EPMSystem11R1/products/Essbase/EssbaseServer/java/udf/
3) Modified the udf.policy file to add an entry for the new CDF:
grant codeBase "file:${essbase.java.home}/udf/smartListFootnotes.jar" {
permission java.security.AllPermission;
};
4) Executed a MaxL command to register the new function -- completes successfully in EAS without errors. The function is displayed when clicking on [Server] > Edit > Functions...
create or replace function 'MyApp'.'@JFNCODE'
as 'smartListFootnotes.getFootnoteCode(double, String)'
spec '@JFNCODE(sl_index, sl_name)'
comment 'New custom CDF'
5) Stopped and restarted the selected Application using EAS but receive the following error:
[Mon Aug 3 18:04:00 2015]Local/MyApp///139996758001440/Warning(1200490)
Wrong java method specification [smartListFootnotes.getFootnoteCode(double, String)] (function [@JFNCODE]): [specified class not found:smartListFootnotes]
Any suggestions on how to resolve this would be greatly appreciated!
Thanks
Taha S.