Skip to Content
0
Mar 20, 2015 at 09:45 AM

script logic problem

24 Views

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