Dear SDN Experts,
May I ask you for some pointers.
I have a planning function that distributes a lump sum to a set of existing dataset by reference.
The original key figure value of the referenced records should be overwritten by the function after distribution.
What actually happened was, the function-generated value that is distributed from lump sum, non-detailed level record to the detailed level records (reference data) was added to the existing value in the referenced records. The referenced record is to be changed (overwrite) by the distribution at the same time that it is also serving as the reference for the distribution function. This means, the existing record is not negated and yet a same key record is inserted with the distributed value.
From the cube perspective, selecting the same record shows the summation. However, the lump sum value record was shown in the cube as being negated.
Please could you advise me how to set the cube to remove the existing value and insert the function derived value?
Message was edited by: to correct syntax error.