Enhance Fox Formula - Multi planning area 4TPM5000

[Former Member]

Hello BI gurus,

I want to enhance a standard Fox Formula in Planning Area 4TPM5000.

The fox formula brings data from one cube in APO into a cube in BI. I need to include extra fields in this mapping but I do not understand what the logic behind the fields mapping order is – from one Planning Area 4TPM6000 (APO cube) into Another Planning Area 4TPM7000 (BI cube).

{0BASE_QTY,#,#,CRMUOM,CRMBP,CRMDATE,CRMPROD,#,

CRMVERSIO,CRMVTYPE,#,#,#,4TPM7000 } =

{ZASPLANB,#,#,#,#,APODATE,#,APOUOM,#,#,

APOLOC,APOMAT,APOVERSIO,4TPM6000 }.

What I want to do is basically add 0CUSTOMER in this mapping - from 0CUSTOMER in the APO cube into 0CUSTOMER in the BI cube.

Any help would be really appreciated!

Alexandra

[Former Member]

you need to ensure you have 0CUSTOMER included in your planning level, then you nede to add it to the fields to be changed in the FOX function definition, then ni the FOX code you insert it into those statements in the appropriate position (the order is displayed above the code window)