Time Dependent DataSources from DB Connect Oracle

[Former Member]

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

[Former Member · Accepted solution]

Hi all

Logged the defect with SAP and they supplied two Notes which resolved the issue.

Note 1942156 - Invalid time selection for loading

Note 1053165 - DB connect: Direct access improvements

Regards

Chami

[colm_boyle]

Hi Chami,

You need to mark the fields 'DATETO' and 'DATEFROM' as selection fields
in RSA6 in your source system.

Notes 324684 and 310304 give more information.

  In 3.x data flow dates selection are in Update tab, in 7.0 data flow dates selection are in Selection tab.

I can confirm with you the design has changed in BI 70 for DataSource, It's normal that you don't see the Time-Dependent Data section in the Update tab, because the field names are 'BEGDA' and 'ENDDA'. This works as designed.

   In order to qualify for Time-Dependent data, the field name HAVE TO BE: 'DATEFROM', 'DATETO' or 'DATE_FROM', 'DATE_TO' and field type = Dats and Selection = 'X' or 'M'.

Hope this answers your question,

thanks,

Colm

[Former Member]

Hi Colm

You are correct, the field needs to be called DATETO or DATE_TO and DATEFROM or DATE_FROM in order to work. They also need to be of type DATS.

However as we are applying a char conversion as we are extracting from Oracle via DB Connect it looks like it will not work.

Thanks

Chami

[MGrob]

Hi

Have you got this time dependent masterdata got to work before with a non sap interface? I don't think this is designed to work with other than SAP source systems.

hope that clarifies

Martin

[KamalMehta]

This should work ideally . It is like any normal selections that we defined at inof package level for any kind of extraction.

Try activating it and running it again. If not then try to create OLAP selection variables with i_step < 2 .

Thanks

[former_member182470]

Are you able to see the data with Date to and Date from fields range in your View in your oracle system?

If yes, then your infopackage should also work in the same fashion.

Just activate the datasource and try with a new infopackage. If nothing works for you, then you are forced to go with ABAP.

[Former Member]

Yes the data is coming through correctly, just that the Time Dependent selections in the InfoPackage do not work.

[former_member182470]

Then, go with ABAP idea..Else..

Activate the RFC between your BW and Source system once. Replicate your datasource and create a new infopackage.