ODS Issue

Hi All,

<b>CASE</b>: We are loading the datafile from non sap system into BW for a file called Billing datafile(ascii).

Our objective is to build Billing Cube from Billing ODS.

<b>situation:</b> Billing data file is loaded in the Billing ODS.

Billing Update data file is then loaded, where each row leads to update of billing ODS row already loaded.

Billing Cube is then built from data in Billing ODS

<b>Problem facing </b>:

Bill cube shows duplicate rows for a billing line item (where single row is expected) with only one field’s value repeating and all other field values being 0 in duplicate record.ODS shows single row for the billing item in question.If Billing cube is dropped and re-created, duplicate rows go away.

What is the possible best solution to avoid duplicate records and to load all other fields values.

Points will be assigned on reply