Duplicated Values in BPC cube

[Former Member]

I am facing an issue in BPC, when i enter the transaction data in the model using excel or web interface, BW generates two records for the same entry. One record is the actual value the positive one while the other record is with the negative value.

Would be grateful if some one suggest the solution.

[Former Member]

Hi Saad,

This is how BPC works, it clears the original value by submitting a negative, then post the actual new value.

if you report the value then it will be the summation of those entries.

you can run light optimize to combine those records into one.

Andy