DB Connect DataSource PSA records and DSO records are not matching...

[former_member189979]

Dear All,

I'm working with SAP NetWeaver BW 7.3 and for the first time, I have loaded from Source System DB Connect. I have created a DataSource and pulled all records and found 8,136,559 records in PSA. When I designed and created DSO with Key Fields 0CALDAY, Item No and Company Code, it has transferred records about 8,136,559 and added records about 12,534 only. Similarly following InfoCube has about 12,534 records into its Fact table. When I tried to reconcile the data/records with source DBMS for a month, the records/data could not matched?

1. What could be the reason behind the issue? why I am unable to load the records/data correctly?

2. Have I not mentioned the Key Fields of DSO in a correct manner?

3. Is it possible to load the records/data into DSO without giving any field as Key Fields?

4. How should I resolve this issue?

5. Is it could be of DSO Overwrite and summation function utilization if yes, then how to utilize it?

Many thanks,

Tariq Ashraf

[former_member182997 · Accepted solution]

Dear Tariq,

1. What could be the reason behind the issue? why I am unable to load the records/data correctly?

Ans:  Check transformation once. Is there any start routine you have used or direct assignments. What kind of DTP settings you have done.
Check the messages at the DTP monitor. You will surely find some clue. Any duplicate records are being detected or not check once if you are using semantic keys in your DTP.

2. Have I not mentioned the Key Fields of DSO in a correct manner?

Ans:  The transformation key and the DSo key are they same in your case?
What kind of DSO is it? Like for sales order DSO you take Order number as a key field., So you have to define the key fields according to business semantics I suppose. Do you agree?

3. Is it possible to load the records/data into DSO without giving any field as Key Fields?

Ans:  I dont think so as the keys you defined will help in having unique data records isnot it?

4. How should I resolve this issue?
Ans: Please check the above as in Ans:1 please share your observation.

5. Is it could be of DSO Overwrite and summation function utilization if yes, then how to utilize it?
Ans: DSO overwriting of key figures is useful when you have full loads in picture. Are you always going to perform full loads ?

For reference would you like to check this thread: 

Lets see what experts give their inputs.

Thank You...

[former_member189979 · Accepted solution]

Hi,

Thank you so much for your prompt reply.

1. In the Transformation, I have not used any "Start Routine" and all the assignments are direct mapping or assignments. Secondly, I have not used any DTP settings for filter.

2. The DSO keys are InfoCube keys are the same one. It is "Standard DSO".

3. Since, I'm fetching from DB Connect source system and therefore, I will do my Full Load between DataSource and DSO and will perform delta load from DSO to InfoCube.

4. Have I missed something or do I need to reconsider my Key Fields?

Many thanks!

Tariq Ashraf

[Former Member · Accepted solution]

Hi Tariq,

Such issues could occur if Key set up in DSO or data is not correct.

rather i suggest you to analyze the data between DSO and Flat file with any lower level of character value. There could be more reason for such issue -

a) DSO Key field set up is not suitable (this set of key fields should bring unique record.

b) Key figure update mode in DSO, if there are many lines for same key fields set up then you need to use summation mode in DSO, otherwise last line will be used only and others will be overwrite in DSO.

Your 2nd and 3rd points are ok.

Thanks.

[former_member189979 · Accepted solution]

Hello Sum,

Thank you so much for your reply. I have changed my Key Fields set and now going to reload my data till DSO and then I will see whether or not its being correctly loaded or not.

1. But I'm still confused about the usage of update mode of Key Fields should I change it to summation or keep it to overwrite.?

2. Source data is correct one, what else would you suggest?

Many thanks,

Tariq Ashraf

[Former Member · Accepted solution]

Oky this update mode details like this.

If your Flat file has multiple value for same set of key then you need summation if not then overwrite is fine in update mode for DSO.

Sure this will solve your problem.

Just check with small data as a test case.

[Former Member · Accepted solution]

Are you able to solve the issue?