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 ??