Question:
Dear BW Gurus,
I am having MSS (Non R/3 ) system as one of the source system to BW 3.0B and datsource is based on view in MSS which is having date field. Is it possible to generate delta upload mechanism for this datasource and if yes, how?
Thanx & regrads,
Answer:
Hope it helps you .....
If your MSS System supports database triggers, you can wite a delta changes to a separate table and pull the information from the delta table.
(or)
General Ledger works as below ...try this
Financial Accounting line items are read by extractors directly from the tables in the SAP R/3 system. A time stamp on the line items serves to identify the status of the delta data. Time stamp intervals that have already been read are then stored in a time stamp table. The delta dataset is transferred to the BW system directly, without records being transferred to the delta queue in the SAP R/3 system (extraktor delta method).
The Financial Accounting line items are extracted from the SAP R/3 system in their most recent status (after-image delta method). This data method is not suitable for filling InfoCubes directly in the BW system. To start with therefore, the line items must be loaded in the BW system in an ODS object that identifies the changes made to individual characteristics and key figures within a delta data record. Other data destinations (InfoCubes) can be provided with data from this ODS object.
Answer:
If the data in MSS System in NOT re-instated, then you could do a full load into any ODS object and then do a delta into your data target.
Dear BW Gurus,
I am having MSS (Non R/3 ) system as one of the source system to BW 3.0B and datsource is based on view in MSS which is having date field. Is it possible to generate delta upload mechanism for this datasource and if yes, how?
Thanx & regrads,