on 05-27-2016 2:21 AM
Hi Guys,
Can anyone help me with the below query -
I have Sql database as my source and BW as my target for BODS jobs.
All my connections are working and could push data in BW successfully.
Now, I need to create a delta based on the date selection from Data Selection tab in BW.
ERDAT is the date field that is loaded in to BW structure and marked as selection enabled.
How do I use this field to define my delta?
BW person will select the dates manually or automate through ABAP code.
I need to pick the dates and run the load as per the date range.
Really appreciate any help on this!!!!
Thanks,
Shilpa
Please refer the below post
Get the Latest Updated Datetimestamp in a Global Variable and use this Global variable in SAP BW
As per my understanding the data flow should be as below:
1. Source>Query_Transform>Template table(Staging)
2. Store the max (Update Timestamp) in one staging area.
3. Use a script and store the maximum datestamp in a variable called $Last_Modified_Timestamp
4. Source>Query_Transform > SAP BW Target(Infocube or DSO)
Use a where clause like LAST_UPDATED_DATE>= $Last_Modified_Timestamp
and this update time stamp value should be deleted and updated every time.
BW handles delta mechanism based on Change log table so it will take care of delta mechanism.
I dont have an environment to test this scenario but above data flow should work with some tweaks
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.