First method- EVALUATE Function.

First method- EVALUATE Function.

Second method- Changing with custom Date format in the Data format.



Third method- Casting with Date format.





And the final comparison of the above three methods.



And also try the below formatting in the RPD side-

-In the physical layer in the schema general properties-try to change the types after searching for DATE.
-the execute on connect of the connection pool write the below code-
ALTER SESSION SET NLS_DATE_FORMAT = 'MON-YYYY'


Comments are always welcome and please add on if

 

 

Evaluate function in 11g

we can use DB function from OBIEE . this is nt a new feature for obiee 11g . this function is already existed in 10g also.

syntax :
Evaluate(function(%1...%n) as datatype,param1,param2..paramn)
where
%1...%n are parameter of function which we want to call the db function.
Param1,param2,..paramn are parameter.

example:

evaluate(substr(%1,%2),'srinivas',3)

resultant function look like in db:

substr('srinivas',3)

result :
nivas