Example: Period Aggregation 

For setting up top-down distribution for planning and actual data, you have the option of specifying a period aggregation for the reference data (using the Aggregate periods indicator).

The following example will seek to demonstrate the difference between distribution with and distribution without period aggregation. It refers to the distribution of actual data but can also be applied to planning data.

The actual data for the periods 01.1999 through 03.1999 that is not posted to specific divisions is distributed to divisions corresponding to the actual data for the periods 01.1998 through 03.1998.

Actual data to be distributed:

Division

Period

Value

#

01.99

24

#

02.99

30

#

03.99

40

 

Reference data:

Division

Period

Value

01

1.98

9

01

2.98

10

01

3.98

5

02

1.98

3

02

2.98

5

02

3.98

5

 

Distribution without period aggregation:

Period

Distribution relationship between
division 01 and division 02

New data records

Period

Division

Value

01.98

9:3 ® 3:1

01.99

01

18

02

6

02.98

10:5 ® -{}- 2:1

02.99

01

20

02

10

03.98

5:5 ® -{}- 1:1

03.99

01

20

02

20

 

Distribution with period aggregation:

Period

Distribution relationship between
division 01 and division 02

New data records

Period

Division

Value

01-03.98

24:13

01.99

01

16

02

8

02.99

01

19

02

11

03.99

01

26

02

14