FOX formula using multiple Infocubes in IP

34 Views

Dear Gurus,

I have created a Multiprovider on 3 Info Cubes and on top of the MP I have created a Agg Level and then created a planning funciton (Formula) to work out some calculations.

Please see the below details:

BOM Structure(CUBE1)

Material Plant Cost Centre Cost Element IC Qty UOM

12345 ABC CC1 CE0001 X 11.6 H

12345 ABC CC1 CE0002 X 9.5 H

Production Volume(CUBE 2)

Material Plant Period Vol UOM

12345 ABC 001.2010 5000 KG

12345 ABC 002.2010 6000 KG

I would like to calculate the volumes as below.

Activity Volumes(CUBE3 u2013 Result Cube)

Material Plant Cost Element Period IC AVol UOM

12345 ABC CE0001 001.2010 X 11.6*5000 H

12345 ABC CE0001 002.2010 X 11.6*6000 H

12345 ABC CE0002 001.2010 X 9.5*5000 H

12345 ABC CE0002 002.2010 X 9.5*6000 H

So onu2026

I have written below code to get the CUBE3 output but nothing is happening, can any one suggest the alternate approach or changes to the below code.

Operand:{Key figure name, 0COSTELMNT, 0FISCPER, 0INFOPROV, 0MATERIAL, 0PLANT, 0UNIT}

FOREACH MATERIAL,PLANT.

QTY = 0.

QTY = {ZQTY,COSTELMNT,#,'CUBE1',MATERIAL,PLANT,UOM}.

PVOL = 0.

PVOL = PVOL + {G_BD_NTKG,#,PERIOD,'CUBE2',MATERIAL,PLANT,KG}.

IF PVOL <> 0.

VOL = 0.

VOL = PVOL * QTY.

{ZVOLUME,COSTELMNT,PERIOD,'CUBE3',MATERIAL,PLANT,UOM} = VOL.

ENDFOR.

Please help me to resolve the issue.

Thanks Heaps.

Regards,

Krish