Hello Experts,
I am getting following error while validating below mentioned script logic.
No members found in dimension "Account" for condition "CALC" = "N"
*LOOKUP EXCHANGE_RATES
*DIM R_ACCOUNT="AVG"
*DIM R_ENTITY="Global"
*FOR %LOOP_CUR%=EUR,USD
*DIM C_%LOOP_CUR%:INPUTCUR="%LOOP_CUR%"
*NEXT
*ENDLOOKUP
*FOR %LOOP_CUR%=EUR,USD
*XDIM_MEMBERSET TIME = $Y$.01,$Y$.02,$Y$.03,$Y$.04,$Y$.05,$Y$.06,$Y$.07,$Y$.08,$Y$.09,$Y$.10,$Y$.11,$Y$.12
*XDIM_MEMBERSET RPTCUR = %LOOP_CUR%
*XDIM_FILTER ACCOUNT = [ACCOUNT].PROPERTIES("EX_RATE")="%LOOP_CUR%"
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*WHEN STATISTIC
*IS ST_118
*REC(EXPRESSION=-%VALUE%*LOOKUP(C_%LOOP_CUR%),RPTCUR=LKR,STATISTIC=ST_236)
*ENDWHEN
*NEXT
Thanks & Regards
Bhagyesh Ravange
Ups, try to use another variable in the second FOR/NEXT loop:
...
*XDIM_MEMBERSET TIME = $Y$.01,$Y$.02,$Y$.03,$Y$.04,$Y$.05,$Y$.06,$Y$.07,$Y$.08,$Y$.09,$Y$.10,$Y$.11,$Y$.12
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*FOR %L_CUR%=EUR,USD
*XDIM_MEMBERSET RPTCUR = %L_CUR%
*XDIM_FILTER ACCOUNT = [ACCOUNT].PROPERTIES("EX_RATE")="%L_CUR%"
*WHEN STATISTIC
*IS ST_118
*REC(EXPRESSION=-%VALUE%*LOOKUP(C_%L_CUR%),RPTCUR=LKR,STATISTIC=ST_236)
*ENDWHEN
*NEXT
Add a comment