Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Evaluate function

ManoSep 24 2012 — edited Sep 24 2012
Dear All

Our users wanted a date field in 'DD-MON-YYYY' format. We didnt have it anything as such format , hence we wanted to create a new column called "Date From" , for this i have copied a column "Bill From' and renamed the filed as Date From. Now under the expression builder , i have used the evaluate function something like below.

EVALUATE('TO_DATE(%1,%2)' AS Date , "Oracle Data Warehouse"."Catalog"."dbo"."Dim_OKS_Contract"."BILL_FROM", 'DD-MMM-YYYY')

While no error is occurring while saving the RPD , but getting error "Error retrieving values" in answers when trying to select the values in answers filters of this column.

Can somebody please help me how can i correct this?

Regds
Mano
This post has been answered by Satya Ranki Reddy on Sep 24 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2012
Added on Sep 24 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
1,332 views