on 01-28-2013 12:21 PM
Hi everybody,
I m trying to move data from ECC6 to SAP BW 7.3 InfoCube.
I created a delta data source with the option "Additive delta", I also created an Infopackage to initialize data and an other InfoPackage to fetch new/modified data. Finally I created an InfoCube and a DTP to get data from PSA to the InfoCube.
my problem is when I modified the quantity of an purchacing order item, I found both the old and the new value in the InfoCube !!!
for example: I modified a PO item
PO Item | Quantity
Old Value 4500000002 | 14000.00
New Value 4500000002 | 16000.00
In the InfoCube I found both entries.
Please tell me did I do somthing wrong?
Thank you in advance.
I suppose you didn't map 0RECORDMODE?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, 0recordmode is a technical infoobject which determines how records have to be updated. If you search on the forum, you will find tons of topics concerning this. f.e. recormode = N means it is a new record, R is a reversal record, X is a before image (the old situation) whereas ' ' is an after image (the new situation).
If you do not map 0recordmode in a transformation, it will always be blanc, so all records will be considered as after images => double data.
f.e. old situation 14000
new situation 16000
This will give 2 records in your infocube.
Now what I do not understand is the fact you say you created an additive delta.
This means in your PSA you should see something like this:
recordmode amount
N 14000
2000
If that is the case, I think you do a full load from the DTP.
Can you check what you see in the PSA? And also if recordmode is mapped in the transformation (you can find it in the technical rule group)
Hi, Thank you for your explication
When I was creating the generic data source, I chose the option 'additive data', please see image below:
After reading few documentations on the ROCANCEL filed and 0RECODMODE InfoObject, I understood what they mean.
You right, I haven't mapped the 0RecordMode in the transformation!
below the trasformation:
I have one Key Figure that is the PO item quantiy, and all the characteristic are defined as Primary key. So can you tell me how can I map the 0RecordMode?
Thank's in advance
Hi, Thank's for replying.
Why should I add the AEDAT in the infoCube?
If I inlude it in the InfoCube, it will be part of the primery key. Therefore when I change a record in the EKPO table, it will be concidered like a new record!!!
Example:
AEDAT | PO Item | Quantity
27/01/2013 |4500000002 | 14000.00
28/01/2013 |4500000002 | 16000.00 new record (Different AEDAT value)
Please tell me if I am misunderstanding something!
Should I use ODS to get data in the InfoCube? because we don't have any needs to use ODS for reporting.
I just need to feetch data from ECC tables to BW InfoCube and use SAP Business Objects on BW
Thank you a lot for your help
Hi,
Below I m posting snapshots that view data fetched by 2 requests: the first is for inityialisation and the second is after I changed one record (PO Item 4500000002)
First Request:
The second request (After I changed the quantity):
After running a DTP, this is what I get in the InfoCube:
Please tell me how can I do to avoid duplicate data?
Thnak's in advance
Right, I see what the problem is:
your extractor provides you not with an addititve delta, but only with after images.
A true additive delta would provide you with 14000 and 2000.
That being said, the solution:
the easiest way is to put a DSO between the datasource and your cube.
Set the key figure to overwrite, and also pay attention to the key of your DSO.
Like this you will always have the latest situation of your data:
- 14000 enters in the DSO
- 16000 enters the DSO, it has the same key so will overwrite the 14000.
Afterwards load towards the infocube.
Another way, but more complex is to generate reversal records (recordmode R), but I'd suggest you start by putting a DSO between the DS and Cube.
That is also the best practice.
Hi Bahy,
Thru DSO only we can get the images for chanegd records in change log table. its best practise use DSO as staging here.
below link will be undestandbale regarding dso
http://scn.sap.com/thread/3299703
Thanks
I thank you a lot for your help.
Like you said, I will work on putting a DSO to get data to the InfoCube.
I never used a DSO, that may take me a time. I will return to you if needed.
Thank you again
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi bahy,
Regarding Additive delta, below link will be useful.
http://scn.sap.com/message/9970122
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
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.