on 10-13-2008 2:56 AM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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
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
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!
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
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!
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 ....
point assigned!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.