Skip to Content
0
Former Member
Feb 18, 2009 at 11:55 AM

FOX Formula not working

92 Views

Hi,

I am not able to copy the value of a key figure from one plan cube to another plan cube, I have created multiprovider on both cubes and aggregation level on multiprovider.

DATA A1 TYPE 0CM_HIEID.

DATA A2 TYPE ZSBUH.

DATA A3 TYPE 0FISCYEAR.

DATA A4 TYPE ZSEASNCT.

DATA A5 TYPE 0INFOPROV.

DATA B1 TYPE 0CM_HIEID.

DATA B2 TYPE ZSBUH.

DATA B3 TYPE 0FISCYEAR.

DATA B4 TYPE ZSEASNCT.

DATA B5 TYPE 0INFOPROV.

DATA KYF_ZGRTE_CY TYPE F.

FOREACH A2.

IF A5 = 'ZICHRPP1'.

KYF_ZGRTE_CY = {ZGRTE_CY,'ZICHRPP1',A2}.

FOREACH B2.

IF B2 = A2.

IF B5 = 'ZICHMPP2'.

{ZKF_HKB,'ZICHMPP2',B2} = KYF_ZGRTE_CY.

ENDIF.

ENDIF.

ENDFOR.

ENDIF.

ENDFOR.

Operand:{Key figure name, 0INFOPROV, ZSBUH}

I am trying to copy value of KF ZGRTE_CY from infoprovider ZICHRPP1 for all A2 to KF ZKF_HKB in infoprovider ZICHMPP2 for the same ZSBUH. After executing this planning seq, its reading records from source cube but no new record is generated or created. Pls help.