Skip to Content
0
Former Member
Dec 19, 2006 at 03:17 AM

Enhance Fox Formula - Multi planning area 4TPM5000

36 Views

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