This content has been marked as final. Show 3 replies
Thanks for reply,
My issue is that there are a bulk of reports which are working fine with older version of OBIEE 10g.
I did a new installation and facing this issue. Now, its not possible to change all the reports or prompts.
What I need is a way may be a change in some script so that date selected in calender is passed in the same format to query via presentation variable.
Like in calender, its in the format 'MM/DD/YYYY' whereas in query its being passed as 'YYYY-MM-DD' which is creating the issue. I want the value selected in calender to be received in the format 'MM/DD/YYYY'.
Thanks & regards
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.
EVALUATE('TO_CHAR(%1,%2)' ,"Dim- Date".Start Date,'DD-MON-YY')
EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER ( 30 ), "Dim- Date".Start Date, 'MON-YY')
Awards points it is useful.