Formula element ATRV could not be recognized

[Former Member]

Hi,

Problem in SAP IP FOX Formula.

I have to copy the data from one cube to other.Both are planning cubes.

I have a customer master YL_AGG1 which has a Attribute YL_COMMU (Ref object of YN_COMMU).

Based on other dimensions I have to copy the data, where YL_COMMU is not equal to 'CAP'.

This is my formula which is giving error massage

'Formula error: Formula element ATRV could not be recognized'

DATA VAR_AGG1 TYPE YL_AGG1.

DATA L_FACTOR TYPE F.

FOREACH VAR_AGG1 IN REFDATA.

IF ATRV ('YL_COMMU', YL_AGG1) = 'CA' .

{ YL_WEIGHT, YLM05_C, VAR_AGG1 } = { YL_WEIGHT, YLM04_C, VAR_AGG1 }

ENDIF.

ENDFOR.

Thanks and regards,

Deepak

Edited by: DEEPAK SINGH on Sep 15, 2008 1:29 PM

Edited by: DEEPAK SINGH on Sep 15, 2008 1:29 PM

Edited by: DEEPAK SINGH on Sep 15, 2008 1:29 PM

[Former Member · Accepted solution]

Hi,

You can try the following line code:

IF ATRV ('YL_COMMU', 'YL_AGG1') = 'CA'

AleX

[Former Member]

Hi,

Don't use the ATRV statement directly in the IF statement. Try by first assigning the result of the ATRV statement to a variable in the fox code, and then use this variable in the IF statement.