cancel
Showing results for 
Search instead for 
Did you mean: 

ODS Update Type

p_m8
Participant
0 Kudos

ODS support the following Update Type:

Addition

Overwriten

No Update

However, in the Update Rule, I have only Overwriten and No Update for Characteristic.

For Key Figure, I have Addition, Overwriten and No Update.

Please confirm if this is correct,

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear mphilip,

However, in the Update Rule, I have only Overwriten and No Update for Characteristic.

For Key Figure, I have Addition, Overwriten and No Update.

--> Correct. For characteristic(like material no, customer no...) you can over write only or No update.

For Keyfigure(like Amount, Qty) you can do addition or overwrite or no update.

Hope it Helps

Srini

p_m8
Participant
0 Kudos

In that case, let say I have the following record already in the Active Table (PO Number is the Key):

(Characteristic) PO Number 115890083, (Key Figure) Qty 10

Now, I choose to use Addition for the Key Figure in the Update Rule.

If I load the following record (same PO) into ODS again:

(Characteristic) PO Number 115890083, (Key Figure) Qty 20

Does it mean I will have the following result (Key Figure = 30) in the Active Table??

(Characteristic) PO Number 115890083, (Key Figure) Qty 30

And if I choose to use Overwrite for the Key Figure in the Update Rule, and load the following record:

(Characteristic) PO Number 115890083, (Key Figure) Qty 20

I have the following result in Active Table (Key Figure = 20) because it is Overwriten?

(Characteristic) PO Number 115890083, (Key Figure) Qty 20

In that case, normally, we should always choose to use Overwrite option for the Key Figure right?

Please confirm.

P/s: Point assigned!

Former Member
0 Kudos

Hi Linda,

Yes, your understanding is corerect. In case of update type addition result will be 30 and it will be 20 for overwrite.

Usually, we use update type overwrite in DSO. As a result Active table contains the current snapshot from source system and the change log table will store the changes.

Regards,

Praveen

Former Member
0 Kudos

Yes Linda,

Update type depends on datasource also. Some dataasources only supports addition and some are overwrite(type of delta).

Please check: [Example for Updating Data into an ODS Object|http://help.sap.com/saphelp_erp2004/helpdata/en/f9/45503c242b4a67e10000000a114084/frameset.htm]

Hope it Helps

Srini

p_m8
Participant
0 Kudos

Thanks Praveen.

Hi Srini,

Thanks for the add info.

So if the datasource only support Full Load, then it is only have option Addition only in the Update Rule.

And if the datasource support both Full and Delta, then we have option Addition or Overwrite in the Update Rule.

Correct?

P/s: points assigned!

Former Member
0 Kudos

Linda,

So if the datasource only support Full Load, then it is only have option Addition only in the Update Rule.

--> No. Full upload can be done in addition or overwrite. For example: when we are loading into a CUBE we can do only Addition. For ODS overwrite also possible.

Decision depends on our requirement.

And if the datasource support both Full and Delta, then we have option Addition or Overwrite in the Update Rule.

--> Not necessarily.

Some datasources, like 2lis_02_ITM can only load to CUBE means only addition possible. But this particular datasource support FULL and Delta aswell.

Hope it Helps

Srini

p_m8
Participant
0 Kudos

Srini,

Thanks, one last question.

1) So all the data loaded into Cube can have only Addition/No Update... regardless of Full or Delta.

For ODS, it can be Additon only, and Addition OR Overwrite option. Exactly where we can see/know that this datasource support only Addition, and Addition or Overwrite option in ODS? Where is the indicator in DataSource control this?

Point assigned!

Former Member
0 Kudos

hi ,

check this blog for detail info ..

Regards,

Shikha

Former Member
0 Kudos

Hi Lynn,

You can check, at RSA2 --> Display Datasource --> Delta Process.

Delta can be one of the following options.

Delta Only Via Full Upload (ODS or InfoPackage Selection)

A ALE Update Pointer (Master Data)

*ABR *Complete Delta with Deletion Flag Via Delta Queue(Cube-Comp)

ABR1 Like Method 'ABR' But Serialization Only by Requests

ADD Additive Extraction Via Extracto (e.g. LIS Info Structures)

ADDD Like 'ADD' But Via Delta Queue (Cube-Compatible)

AIE After-Images Via Extractor (FI-GL/AP/AR)

*AIED *After-Images with Deletion Flag Via Extractor (FI-GL/AP/AR)

AIM After-Images Via Delta Queue (e.g. FI-AP/AR)

AIMD After-Images with Deletion Flag Via Delta Queue (e.g. BtB)

CUBE InfoCube Extraction

D Unspecific Delta Via Delta Queue (Not ODS-Compatible)

E Unspecific Delta Via Extractor (Not ODS-Compatible)

FIL0 Delta Via File Import with After-Images

FIL1 Delta Via File Import with Delta Images

NEWD Only New Records (Inserts) Via Delta Queue (Cube-Compatible)

NEWE Only New Records (Inserts) Via Extractor (Cube-Compatible)

ODS ODS Extraction

X Delta Unspecified (Do Not Use!)

Can also check at Table: RODELTAM. and also check blog suggested by Shika, contains a lot of info..

Hope it Helps

Srini

Dont forget to close the call, by assigning points ....

Answers (1)

Answers (1)

p_m8
Participant
0 Kudos

point assigned!