Skip to Content
0
Former Member
Apr 02, 2013 at 11:40 AM

Issue with dynamic paramters in select criteria

31 Views

Hi Gurus,

I am trying to write a logic to calculate using member property value for set of records. Here is my logic...

*SELECT(%PRODID%,"[ID]",PRODUCT,"[M_CATEGORY]='LOCAL'")
*XDIM_MEMBERSET PRODUCT = %PRODID%


*FOR %PR% = %PRODID%

*SELECT(%PROCO%,"[MAT_PRICE]",PRODUCT,"[ID]='$PR$'")

*WHEN PRODUCT
*IS %PR%
*REC(EXPRESSION=(%PROCO%*[ACCOUNT].[Sales_Qty]),ACCOUNT = Prod_Cost)
*ENDWHEN
*NEXT

.....

This is giving an Invalid 'Select' statement error.

When i changed

*SELECT(%PROCO%,"[MAT_PRICE]",PRODUCT,"[ID]='$PR$'") statement to

*SELECT(%PROCO%,"[MAT_PRICE]",PRODUCT,"[ID]='C155L1'") (C155L1 - is a product member), logic is working very fine.

Help me in passing dynamic variables in select criteria field.

Regards,

Praveen.