Skip to Content
0
Former Member
Aug 27, 2012 at 06:51 AM

Cumulative data and delta building

27 Views

Hi BI experts

Scenario:

Customer 0FISCPER KYF 1000 003.2012 500

1000

003.2012 550 1000 004.2012 600

In the table above you see the scenario: The data are loaded as flatfile into SAP BW. They have cumulative character.

If 0FISCPER is the same the delta is built correct (overwrite modus).

Let's assume that 0FISCPER is a key characteristic of a DSO.

In period 004.2012 the data come as cumulative figures, which means: key figure is 50 (USD) higher.

Any ideas how to get the 50 USD as delta record for posting into the infocube? Are there any standard means?

Thanks