Distribution by Reference Data to distribute foretasted data based on historic value

[saurav_das]

Dear Experts,

I am trying to distribute the data of 2013 based on the 2012 data. The distribution works but I am not sure of the ratio of distribution.

For E.g.

Reference Data:

Date	Char1	Value
Jan.2012	A	100
Jan.2012	B	200
Jan.2012	C	300
Feb.2012	A	300
Feb.2012	B	100
Feb.2012	C	200

Before Distribution:

Date	Char1	Value
Jan.2013	#	1200
Feb.2013	#	2400

After distribution:

Date	Char1	Value
Jan.2013	A	400
Jan.2013	B	300
Jan.2013	C	500
Feb.2013	A	800
Feb.2013	B	600
Feb.2013	C	1000

So what is happening is the average ratio of A,B,C (4:3:5) is calculated for the entire period (Jan, Feb) and applied for each of the records.

What we would like to achieve is that for each month the ratio of distribution should be based on the historic month instead of an average ration for the entire year.

i.e. for Jan (1:2:3) and for Feb (3:1:2).

Any help or suggestion would be greatly appreciated.

Thanks and regards,

Saurav.

[cornelia_lezoch]

Hi,

is fiscper or fiscper3 included in your aggregation level?

It should be fiscper3 and it may not be a field to be changed.

fiscyear should be defined as the reference - with the offset to the year before.

The the system creates a data package for each fiscper3 and I think that´s what you wanted.

regards

Cornelia

[MGrob]

Hi

Your distribution function needs all characteristics identified to do this. Now its not having fiscper in it thats why the ratio is 4:3:5 as it is aggregated.

Martin