Less number of records in dso

[former_member804071]

I have a composite provider from which I am loading data into the DSO. but I am getting less number of records.

Composite provider data :-

DSO data :-

Please help.

[former_member804071]

martin.maruskin2 We cannot add Week of month as a key in ADSO as Week of month may not be unique always.

[MartinMaruskin]

In that case you will only get the aggregated data only into teh aDSO.

[MartinMaruskin]

Hi Arpit, the data in Composite Provider got aggregated as apparently you do not use Week of month in your target aDSO. If you want to have same data granularity in your aDSO you need to add the Week of month into's aDSO keys.

cheers

m./

[MKreitlein]

Hello Arpit,

what are your DSO key fields?

For me it looks like the 6 records distinguish only in the Week field. If this is not in your DSO key, then it is clear, why only one record remains.

This is BW basic stuff ... you should familiarize with table keys and update modes (add, overwrite)... (and add this information into your question)

BR, Martin