Skip to Content
0
Former Member
Aug 28, 2006 at 09:44 PM

ODS Issue

18 Views

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