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.