Fox Formula--Distribution

[Former Member]

hi!!

i want to distribute by reference data. i have two data cubes. first cube is EXPENSE Cube, second is PARAMETER Cube and i have multi-provider include these cubes.

i want to distribute amount of expense according to months on basis of expense ratio of distribution. Now amount of expense is on basis of years(2011 and 2012). how can i distribute by reference to amount of expense on basis of expense ratio of distribution according to months???

note: expense ratio of distribution is in the parameter cube.

amount of expense is in the expense cube.

Edited by: ESOTERIC on May 12, 2011 4:19 PM

[balajee_sivakumar]

Hi,

You can refer to the below link to know more about "Distribution by Reference" planning function,

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/44/2109287641648fe10000000a1553f7/frameset.htm

Regards,

Balajee

[cornelia_lezoch]

Hi,

why don´t you consider using the standard function - distribution by reference data?

just specify which fields are changing - i.e. month...

specify your refernece data - specify for each char where reference is different from the data that is distributed

and then it´s done

regards

Cornelia