Skip to Content
0
Former Member
Aug 16, 2013 at 09:55 PM

Additive Delta from Custom Extractor not working

31 Views

Hi all,

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

Date Value

16/8/2013 100

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.

Thanks,

David