Add functions

Question

How can we add functions ( width_buckst) in the list of functions available when you go in column edit formula and press function list.

i was able to show the new function by editing functionselector.js but when I try to access the function it throws error which is quite

obvious I missed to configure . Does any one know where the configuration files exists and what

will be the code that need to put ? Any help is appreciated.

Gianni Ceresa · Answer

Doesn't really work like that ...

The functions you see available in the edit formula window are all functions the BI Server knows how to translate into code for the various DB it can talk to (so SQL for Oracle, SQL Server, DB2 etc. but also into MDX for Essbase cubes etc.).

So you can't write functions like that, because you would need to compile them into the BI Server which is of course impossible (except if you are one of the Oracle developers working on the tool, but I hope you aren't ...).

If you want to call a function / procedure which is defined in your physical source you need to use EVALUATE (and the similar functions) to just push the call down to the DB with OBIEE not looking into the function at all and just expecting a result back.

If it's R scripts you can call them, but again you can't add random function like that in OBIEE.