Fox Formula : no records generated

[Former Member]

Hi.

I have a question regarding following fox formula.

The goal is to have a function that creates a new record in my planning cube.

I already created the new variables that I used. There are no errors in this formula.

Can you guys have a look at this formula and give some suggestions? Usefull ones will be rewarded!

**********************************************************************************************

• FORMULA EXAMPLE:

• CHANGE THE VALUE OF THE KEYFIGURE ZQUANTITY OF PRODUCT11

• TO THE VALUE OF ZQUANTITY OF PRODUCT09 TIMES 1.1

• ASSUMPTION FOR FIELDS TO BE CHANGED: ZPRODUCT

• ==> OPERAND: {NAME OF KEYFIGURE, ZPRODUCT}

**********************************************************************************************

• DATA L_FACTOR TYPE F.

• L_FACTOR = 1.1.

• { ZQUANTITY, PRODUCT11 } = { ZQUANTITY, PRODUCT09 } * L_FACTOR.

**********************************************************************************************

DATA CK TYPE 0COUNTRY.

DATA FY TYPE 0FISCYEAR.

DATA CC TYPE ZCOSTCENT.

DATA IO TYPE ZCOORDER.

DATA PL TYPE ZPLGROUP.

DATA COG TYPE ZCOOBJGR.

DATA AM TYPE I.

CK = VARV(ZJANCNTRYNEW).

FY = VARV( CYEAR001).

CC = VARV(ZJANCCNEW).

IO = VARV(ZJANCORNEW).

PL = VARV(ZJANPLGRNEW).

COG = VARV(ZJANCOGNEW).

AM = VARV(ZAMOUNTNEW).

IF CC <>'' AND IO <>''.

MESSAGE E000(ZDEMOIP).

EXIT.

ELSE.

{0AMOUNT,CK,FY,COG,IO,CC,PL}=AM.

ENDIF.

Regards,

Bart

[Former Member]

Hi Brat,

it look's like you have formula variable's in your Fox, firstly, how are you passsing values to those variables? are you using web-application.

CK = VARV(ZJANCNTRYNEW).

FY = VARV( CYEAR001).

CC = VARV(ZJANCCNEW).

IO = VARV(ZJANCORNEW).

PL = VARV(ZJANPLGRNEW).

COG = VARV(ZJANCOGNEW).

AM = VARV(ZAMOUNTNEW).

Thankss,

Sappie

[Former Member]

<Font Face="Tahoma" Color="Blue">

Hi,

You have written that Operand Structure is as below:

==> OPERAND: {NAME OF KEYFIGURE, ZPRODUCT}

And then there is a statement in FOX where operand structure looks somewhat different.

{0AMOUNT,CK,FY,COG,IO,CC,PL}=AM.

Please check it.

Also can you check using "Set Variables" if all the variables used in your FOX are populated with values that you are expecting.

Regards,

Abhijit

*PS: Please reciprocate by assigning points if above response was useful

</Font>

[Former Member]

Do you have all characteristics in the level marked as 'to be changed' for this fox function? If not, try doing that and then execute it.