Skip to Content
0
Apr 30, 2011 at 06:58 AM

Script Logic - Monthly Rolling Forecast

27 Views

Dear Freinds,

I am attempting to write script log for

1) find the monthly YTD difference between Actual and Plan AND

2) Allocate the difference amongh the futhure periods.

For Point 1 I tried below

*XDIM_MEMBERSET TIME =2009.APR ,2009.MAY

*XDIM_MEMBERSET P_ACCT=CE0004010

*XDIM_MEMBERSET CATEGORY=ACTUAL,PLAN

*XDIM_MEMBERSET MEASURE=YTD <----


This is not validating

*WHEN CATEGORY="ACTUAL"

*REC(EXPRESSION=%VALUE%-"PLAN",CATEGORY="PLAN",TIME=2009.MAY)

*ENDWHEN

*COMMIT

Can you please correct me . I am beginer to script logic.

Regards,

Vishwanath Gamanagatti