EVALUATE function can be used in OBIEE to directly to call a Database Function from OBIEE Answers
Syntax:-EVALUATE('your db function(%1,%2)', parameter list)
---%1 and %2 are no.of parameters (in this example 2 parameters will be passed to the database function)
%1, ..., %X means - x number of parameters will be passed, and the values for those parameters will be passed in the parameter list.
Example:
EVALUATE('TO_CHAR(%1,%2)' ,"Dim- Date".Start Date,'DD-MON-YY')
or
EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ), "Dim- Date".Start Date, 'MON-YY')
Syntax:-EVALUATE('your db function(%1,%2)', parameter list)
---%1 and %2 are no.of parameters (in this example 2 parameters will be passed to the database function)
%1, ..., %X means - x number of parameters will be passed, and the values for those parameters will be passed in the parameter list.
Example:
EVALUATE('TO_CHAR(%1,%2)' ,"Dim- Date".Start Date,'DD-MON-YY')
or
EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ), "Dim- Date".Start Date, 'MON-YY')
saichand,
ReplyDeleteis it possible to use this in the dashboard url also?
thanks,
karthick
Hi,
ReplyDeleteHow can we use this Evaluate Function in report
Thnaks & regards
Krishna
In fx (Column formula) we can use
ReplyDeleteHi
ReplyDeletei am creating function called sum()and pas 2 parameters a,b and result in c,
and i am using this function as Evaluate function like Evaluate('Sum(%1,%2)',SH.SALESFACTS."AMOUNT SOLD",SH.SALESFACTS."UNIT COST")....
in the logical column and using this column in answers ...but it show s an error..am i using correctly ,if wrong plz tell me how to do
Thanks & regards
Krishna
In that u should go with evaluate aggr function refer
ReplyDeletehttp://obiee101.blogspot.com/2007/12/obiee-evaluateaggr-function.html