Cube Data

Hi Experts,

I am using a cube provided in business content for reporting. This cube supports delta load. Now, I have added a custom field, X , in CMOD and loading it into Cube. Here is my scenario,

User creates a record in R3 at that time this field X is populating with null. so I have a record in cube with

Business Content field A, B and My field X = Null + Key figures.

When user modifies the same record later and saves. My field X is coming with some value. So Delta (ABR) in cube comes as Field A, B + X= some value + Key Fields.

This is making 2 records in Cube.

Row 1 : A B X= "" Keyfields

Row 2 : A B X( Not Null) Key Fields

How should I overcome this scenario ??