No members found in dimension "Account" for condition "CALC" = "N"

[bhagyesh_ravange]

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

[former_member186338]

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

[former_member186338]

Why not to look here:

And what is your BW and BPC version and SP...

[bhagyesh_ravange]

Thanks Vadim for the prompt reply .

Issue has been resolved by mentioning EUR in "EX_RATE" property in Account Dimension.

[former_member186338]

By the way, if you want to get a list of unique values mentioned in EX_RATE property and also - members of some dimension, you can use:

*SELECT(%NONUNIQ%,[EX_RATE],ACCOUNT,"[EX_RATE]<>''")

*SELECT(%UNIQ%,[ID],RPTCUR,"[ID]=%NONUNIQ%")