I Develop the analytics reports using essbase cube in OBIEE 11g. And i want to call a DB function by passing parameter.
Can anyone Guide me how to do that.I am trying to call function using Evaluate.Below is my syntax.
Evaluate('Function(%1)' as char ,"Accounts"."Gen15,Accounts") here Accounts is the dimension .
For you better understand, I have described example below.
Syntax:EVALUATE('db_function(%1...%N)' [AS datatype] [, column1, columnN])
. Evaluate('substr(%1,%2,%3)' as Char,'satyarankireddy','1','5')
For more details: You can find more examples on below link.
Hope this helps.