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