Hi Experts!!
I have maintained the percentages in Entity dimension under property having HOLIDING_PERCENTAGE
and I am trying to calculate the percentages with the value in accounts.
The logic which I have used is not working, could you please let me know where I am wrong in logic.
*SELECT (%PERC%,"[ID]",ZS_ENTITY,"[HOLIDNG_PERCENTAGE]=ID")
*XDIM_MEMBERSET ZS_ACCOUNT=TOP_PER_UNIT
*XDIM_MEMBERSET ZS_CATEGORY=Plan
*XDIM_MEMBERSET ZS_ENTITY=9000273
*XDIM_MEMBERSET ZS_PRODUCT=LAPTOP
*XDIM_MEMBERSET ZS_RPTCURRENCY=LC
*XDIM_MEMBERSET ZS_TIME=2011.01
*WHEN ZS_ACCOUNT
*IS 1141100000
*REC(EXPRESSION=%VALUE%*%PERC%,ZS_CATEGORY=Plan,ZS_ACCOUNT=1141200000)
*ENDWHEN
*COMMIT