I'm trying to use additive deltas to get the changed value for a key figure from a custom datasource.
Ultimately i want this kind of scenario to view changes over time in the infocube.
user enters 100 units on the 16th - delta load to BW
user decreases the units from 100 to 75 on the 17th - delta load to BW
How the data shows up in the Infocube
17/8/2013 -25 not 75
I've tried sending it to a DSO with 0recordmode set to 'A' and key figures set up as summation aggregation but i do not get the changed value in the active records. I've tried sending it directly to the cube. Does the datasource need to have ROCANCEL in order for the additive delta to work? Does it make a difference if the DSO is keyed by change date or not?
The datasource is set to Additive Delta for the Generic Delta settings
It is based off a FM to capture the Datetime stamp - which is used for the delta specific field (UTC)
I've searched for information on this but have had no luck.
Any help would be greatly appreciated.