Skip to Content
0
Former Member
May 03, 2007 at 07:34 PM

URGENT !!!! Problem with Date format MM/DD/YYYY in oracle database to BW

553 Views

Hi

I am wondering if somebody can help me urgently.

I have oracle database where date is of the format MM/DD/YYYY and I am loading data into BW. DATE data type

Date in oracle database: 3/30/2007

First when I used InfoObject ZDATE (with 0DATE) reference (DATS data type) data load failed saying that

'Value '30-MAR-0 ' of characteristic 0DATE is not a number with 000008 spaces'

Then I created ZDATE InfoObject as CHAR Type (Length 10) with PDATE Conversion Routine.

when I created datasource using DB Connect and checked the contents using 'Display Table Contents' after creating data source the data field distorted as

AR/-0/30-M

After data load. when I checked PSA

The Date records look same as AR/-0/30-M

In cube the field appeared as 30-MAR-0 (last digit of year disappearing)

In BEx report also it looks like 'AR/-0/30-M'

Can somebody help me as quickly as possible.

What should I do if i want to still use DATS data type for ZDATE?

should I change date format in database if so to what?

If I should use CHAR type with PDATE or any other routine can somebody give me the routine to have the date in the report exactly as it appears in database?

I also tried changing date format in user profile...settings. But still its the same.

Thanks in advance.