This website is not affiliated with, sponsored by, or approved by SAP AG.

New to BW - Data Load issue

Business Warehouse

Moderators: Snowy, thx4allthefish

New to BW - Data Load issue

Postby anya_nanda » Wed Nov 07, 2012 4:41 pm

Hi all,

I am loading data from ECC to BW.Data flow has datasource -> Standard DSO-->Cube.

I have 4 fields a,b,c,d in my standard datasource, DSO and Cube. When I first load data I see 3 records in final cube as below

5108 1 1000 blank
5108 2 1040 blank
5108 3 1120 blank

I now go and update field d in ecc with some text for field D. I run the delta load. Instead on updating field d with new texts, I now see 6 records in my cube.

5108 1 1000 blank
5108 2 1040 blank
5108 3 1120 blank
5108 1 1000 text1
5108 2 1040 text2
5108 3 1120 text3

I check the underlying standard DSO but only see 3 records with correctly updated texts as below.

5108 1 1000 text1
5108 2 1040 text2
5108 3 1120 text3

Based on this , I am thinking that the issue is with the transformation between DSO and Cube. But there is no start routine or end routine.Can anyone help me understand what the issue could be.
anya_nanda
 
Posts: 60
Joined: Tue Oct 07, 2003 3:45 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 5 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.