Is there a way to run a stored procedure (using *RUN_STORED_PROCEDURE) only after a certain allocation has run?
// Default base level logic - applies to all base members in all dimensions //Contract Allocation *IGNORE_STATUS *XDIM_MAXMEMBERS ENTITYDIM=12 *RUNALLOCATION *FACTOR USING/TOTAL *DIM ACCOUNTPRS WHAT=>>>; WHERE=SALES; USING=<<<; TOTAL=<<<; *DIM DATASRC WHAT=ALLOCATION; WHERE=INPUT; USING=INPUT; TOTAL=<<<; *DIM CONTRACTENTITY WHAT=; WHERE=; USING=; TOTAL=; *DIM SYSTEM WHAT=FCST_MEMBER; WHERE=BAS(ALL_MEMBERS),[ACTIVE]='Y'; USING=[ACTIVE]='Y'; TOTAL=<<<; *DIM CATEGORY WHAT=FCST; WHERE=<<<; USING=ACTUAL; TOTAL=<<<; *DIM MANAGINGCO WHAT=; WHERE=; USING=; TOTAL=; *DIM MEMBERCLASS WHAT=FCST_CLASS; WHERE=BAS(ALL_CLASS); USING=ALL_CLASS; TOTAL=<<<; *DIM PRIMETYPE WHAT=FCST_PRIM; WHERE=BAS(PRIME_TYPE); USING=PRIM_TYPE; TOTAL=<<<; *DIM TIME WHAT=YYYY.MONTH; WHERE=<<<; USING=<ALL>; TOTAL=<ALL>; *DIM ALLIANCE WHAT=; WHERE=; USING=; TOTAL=; *DIM SUPTIME WHAT=%SUPTIME_SET%; WHERE=%SUPTIME_SET%; USING=TOTAL.2009; TOTAL=<<<; *ENDALLOCATION *COMMIT *RUN_STORED_PROCEDURE=SPBUDCALC();
Edited by: Nick Wills on May 20, 2010 4:46 PM