Skip to Content
0
Former Member
Nov 13, 2012 at 01:44 PM

Script logic - multiple period/month copy

32 Views

Hi,

Currently users have to run the copy process 4 times to copy the periods/months, see below;

1 > 2

1+2 >3+4

1+2+3+4 > 5+6+7+8

1+2+3+4 > 9+10+11+12

I am trying to create a script that will only need to be run once, so far I have triedthe below 2 scripts but only period/month 2 is being fillled;

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P02,%YEAR%.P03,%YEAR%.P04,%YEAR%.P05,%YEAR%.P06,%YEAR%.P07,%YEAR%.P08,%YEAR%.P09,%YEAR%.P10,%YEAR%.P11,%YEAR%.P12;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

Script 2

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P02;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P03;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P04;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P05;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P06;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P07;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P08;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P09;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P10;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P11;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

*RUNALLOCATION

*FACTOR=

*DIM ACCRM WHAT=IDEAL_FORMULA; WHERE=<<<

*DIM CATEGORY WHAT=%CATEGORY%; WHERE=<<<

*DIM TIME WHAT=%YEAR%.P01; WHERE=%YEAR%.P12;

*DIM ENTITY WHAT=NOENTITY; WHERE=<<<

*DIM LINE WHAT=%LINE%; WHERE=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<

*ENDALLOCATION

*COMMIT

Thanks

Rosie