cancel
Showing results for 
Search instead for 
Did you mean: 

Script Logic - Monthly Rolling Forecast

Vishwanathg7
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

Did you try to validate your logic in UJKT? try in Execute (simulate) mode, If you are working in Sandbox execute and see log file.

Coming to allocation of the difference to future months:

Step 1: Write the difference (Plan - Actual) to FX Difference Account (if any).

Step 2: Create allocation logic to spread to the other months.

Thanks,

Former Member
0 Kudos

Hi,

What does it say, when you try to validate your script?

Is your application of type YTD?

Vishwanathg7
Participant
0 Kudos

Dear Sir,

Thanks ! for looking into my problem.

when I try to validate the code its not validating YTD.

My application is PERIODIC.

I want to allocate the current month difference to futhure months in equal proportion.

Rerards,

Vishwanath G

Former Member
0 Kudos

Hi,

Can you kindly let me know the exact message you get?

Is it validating successfully if you dont use XDIM on measure?