Time Dependent DataSources from DB Connect Oracle

70 Views

Hi all

I am extracting data from a non SAP system via DB Connect from an Oracle database. I am trying to load Master data Attributes to a Time Dependent InfoObject in BW.

I have created a view in Oracle and this view contains DATE_FROM & DATE_TO field. The date fields in the view has been defined as to_char(DATE_FROM,'YYYYMMDD') as per SAP Note 518241.

When I created the DataSource in BW I have marked those 2 fields as "Selectable" and with "Lower Limit" and "Upper Limit".

When I create the InfoPackage the Time Dependent Data selections appear in the Update tab. However they do not seem to work, i.e. the same number of records get extracted regardless of what values are entered.

I know that I can write ABAP, but should this not just work? Has anyone come across this before?

Thanks

Chami