on 2008 Jun 09 4:27 PM
Hi
I am trying to load data to the ODS from datasource 2LIS_04_P_MATNR. can do i a delta load to ODS?.
Thanks.
Hi,
To my understanding you can use this DS to load to both ODS and cube. The delta process is ABR.
Read the SAP help on ABR delta process.
Forming deltas with after, before and reverse images that are updated directly in the delta queue; an after image shows the status after the change, a before image the status before the change with a negative sign and the reverse image also shows the negative sign next to the record while indicating it for deletion. This serializes the delta packets. The delta process controls whether adding or overwriting is permitted. In this case, adding and overwriting are permitted. This process supports an update in an ODS object as well as in an InfoCube. (technical name of the delta process in the system): ABR)
http://help.sap.com/saphelp_bw33/helpdata/en/84/81eb588fc211d4b2c90050da4c74dc/frameset.htm
Also there is already a ODS 0PP_DS01 thats standard to this DS.
Refer
http://help.sap.com/saphelp_bw33/helpdata/en/ce/d439ecc0e4164ca95310743faf6f39/content.htm
Hope this helps.
Thanks,
JituK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
it is possible for loading cube only.
A Delta update is supported. Delta process: ABR u2013 Complete delta with deletion indicators using delta queue (Cube-compatible).
Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This DS supports Delta process with ABR u2013 Complete delta with deletion indicators using delta queue. This supports deltas to ODS as well as Cubes.
http://help.sap.com/saphelp_nw70/helpdata/EN/88/7fc73c0c52085be10000000a114084/frameset.htm
Forming deltas with after, before and reverse images that are updated directly in the delta queue; an after image shows the status after the change, a before image the status before the change with a negative sign and the reverse image also shows the negative sign next to the record while indicating it for deletion. This serializes the delta packets. The delta process controls whether adding or overwriting is permitted. In this case, adding and overwriting are permitted. This process supports an update in an ODS object as well as in an InfoCube. (technical name of the delta process in the system): ABR)
http://help.sap.com/saphelp_bw33/helpdata/en/84/81eb588fc211d4b2c90050da4c74dc/frameset.htm
Hope this helps.
Thanks,
JituK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Thanks for the replies..i was confused after looking at the help.sap.com
it says :
A Delta update is supported. Delta process: ABR u2013 Complete delta with deletion indicators using delta queue (Cube-compatible).
This means apart from ODS also Cube compatible or only cube compatible?.
if you look at the below link it says :
Delta update is not supported for this DataStore object. Means not possible in BI 7.0?.
http://help.sap.com/saphelp_nw2004s/helpdata/en/28/500b3c56488e6be10000000a114084/frameset.htm
I am working in 3.5.
Please clarify.
Thanks.
Hi,
Yes , you can.Sure!
There is already a std ODS with this infosource:
http://help.sap.com/saphelp_bw33/helpdata/en/ce/d439ecc0e4164ca95310743faf6f39/content.htm
http://help.sap.com/saphelp_bw33/helpdata/en/88/7fc73c0c52085be10000000a114084/content.htm
Hope it helps!
Regards
CSM Reddy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes it is delta capable
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
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.