Here is my issue
I want to implement below function in obiee.It takes the month from the column and appends the current year .so basically if the column has the value 01/12/12.It becomes 01/12/13.P_year is a current year variable.I am having issues in writing the above code in obiee.I am using the below in obiee which is giving the below error.
SQL FUNCTION: to_date(to_char(Date_Column)||'-'||:current_year,'MM-YY')
OBIEE:CAST(CAST(MONTH("date_column") AS CHAR) ||'-'||CAST(VALUEOF("current") AS CHAR)as date)
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 1843, message: ORA-01843: not a valid month at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)
Please help were i am doing wrong.This is the reaon i want to do this using EVALUATE function.