Skip to Content
0
Former Member
May 20, 2010 at 02:46 PM

Stored Proc after Allocation

27 Views

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