Fox formula

[Former Member]

Hi SDN,

i am having the following senario,for which i need your suggestions as i m new to planning .

Our client using BPS for a company code 10 and they r loading the data from a actual cube to the forcast cube based on a some FOX formula which aggregates based on planning item, job type and job status etc.

now they want the same thing should work for company 20 and 30 ..

i have loaded data upto actual cube but it's not loading to the

forcast cube .

i have changed values in the planning level to both companies and multi currency..but it's not getting thru..showing 0 records read,0 read and 0 changed.

can sombody guide me how to approch i.e which area i need to check and modify etc...POINTS will be awarded .

Thanks & regards,

JV

[Former Member · Accepted solution]

Hi,

Check whether the FOX is working fine for company code 10 or not. If yes, then it should work for other company codes also. The characteristic, Company Code should be present in the fields to be changed. On the left side of FOX, specify the target company code and on right side specify the source company code. Keep the other logic as required.

It would be more easier if you can share the logic while doing the copy.

Hope the first paragraph hjelps. Please award points if helpful.