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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Combining day, month and year column to create a date

695408May 29 2009 — edited Jun 2 2009

Hello,

I have this problem, I try to combine this 3 column that is Day, Month and Year into one column that is date column. I do this in the BMM. Here is my syntax

CAST ( CAST (obiee_cri.TM_DIM.FSCL_DAY_NBR_IN_MNTH AS CHARACTER ( 30 )) || '/' || CAST (obiee_cri.TM_DIM.FSCL_MNTH_NBR_IN_YR AS CHARACTER ( 30 )) || '/' || CAST (obiee_cri.TM_DIM.FSCL_YR AS CHARACTER ( 30 )) AS DATE )

But when I try to drag the table in OBIEE Answers, this error message displayed,

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1843, message: ORA-01843: not a valid month at OCI call OCIStmtExecute. [nQSError: 17011] SQL statement execution failed. (HY000)

So, can anyone tell me what is wrong, can anyone show me the correct way.

Thanks,

Azzad

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2009

Added on May 29 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

5,835 views