2LIS_04_P_MATNR

[NagaM]

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.

[former_member345199]

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

[Former Member]

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

[former_member345199]

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

[NagaM]

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.

[chemicala_srimallikarjuna]

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

[Former Member]

yes it is delta capable