cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate data in BW InfoCube

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I suppose you didn't map 0RECORDMODE?

Former Member
0 Kudos

Hi,

Can you explain more?

Thank you a lot

Former Member
0 Kudos

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)

Former Member
0 Kudos

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

Former Member
0 Kudos

can you post what you see for the item in the PSA?

Like that it will be very clear for me.

Former Member
0 Kudos

Hi,

You r using additive delta on field AEDAT as shown, but it seems ur not using tht field in infocube.

Regards,

Aravind.

RamanKorrapati
Active Contributor
0 Kudos

hi bahy,

you need add a date field in cube, need to map from data source field AEDAT, before infocube better to include  DSO in your data flow to  catch image changes.

Thanks

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

RamanKorrapati
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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

RamanKorrapati
Active Contributor
0 Kudos

You are welcome. always hit back when you need.

Thanks

RamanKorrapati
Active Contributor
0 Kudos

hi bahy,

Regarding Additive delta, below link will be useful.

http://scn.sap.com/message/9970122

Thanks