Skip to Content
0
Former Member
Apr 23, 2010 at 10:30 AM

FOX Formula problem

38 Views

I have a planning cube and a material substitution cube which I have joined with a multiprovider, which I have built an IP aggregation level on. I am trying to read the data from planning cube and if I find an entry in the substitution cube I want to create a new entry for the new substituted material found. At the moment my FOX coding is (i have excluded the data declarations)

FOREACH calmonth, salesorg, infoprovider,material.

if infoprovider = plan.

for each calmonth1, salesorg1, infoprovider1,material1.

if infoprovider1 = subs.

if material NE material1.

{planqty, calmonth, salesorg, infoprovider,material} = {planqty, calmonth, salesorg, infoprovider,material1}

endif.

endif.

endfor.

endif.

endfor.

When I execute with trace, the function is reading the records but not creating new ones.

Am I missing something simple?

Thanks in adavance.