oracle - Understanding evaluate function in OBIEE -

i read stuff on obiee evaluate function , not understand new this.

evaluate('getvalue(%1,''select max(p3_lst37) :strvalue mv_itemsx item_number = xxxx '' )' varchar(2000), "product") 

can please me understand function describe above?

thanks

the evaluate function enables send function database evaluate , return data obiee. security purposes must use references in function rather values themselves.

for example, if have column "core"."date" returns date string , want use to_date function of evaluate, issue following evaluate expression:

evaluate('to_date(%1,'dd-mon-yyyy') date',"core"."date")

hope helps.