Add functions — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Add functions

Received Response
1
Views
1
Comments
user13001889
user13001889 Rank 3 - Community Apprentice

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.

Answers

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