Skip to Content
-1
Former Member
Dec 02, 2016 at 06:14 AM

Allocations - Reference a Dimension property dynamically in the USING section

145 Views

I am trying to do a simple allocation logic based on the received %

Sending CostCentre - CS_SENDER ID POOL_DRIVER CCATEGY 67610 SKF_VEHICLES CSP Receiving CostCentre - COSTCENTRE ID CCATEGY 40180 NSP

//Scope TIME horizon *SELECT(%TIME_HOR003%,HORIZON_Y1,VERSION,"ID = '%VERSION_SET%'") *SELECT(%TIME_HOR004%,HORIZON_Y2,VERSION,"ID = '%VERSION_SET%'") // *SELECT(%CC_DRIV%,POOL_DRIVER,CC_SENDER,"CCATEGY = 'CSP'") *SELECT(%CC_S%,ID,CC_SENDER,"POOL_DRIVER <> ''") //Scope dimension members *XDIM_MEMBERSET VERSION = %VERSION_SET% *XDIM_MEMBERSET TIME = %TIME_HOR001%,%TIME_HOR002% *XDIM_MEMBERSET EMPLOYEE = NO_EMPLOYEE *XDIM_MEMBERSET POSITIONS = NO_POS *XDIM_MEMBERSET PROFIT_CTR = NO_PC *XDIM_MEMBERSET CC_SENDER = BAS(S_LINKALLCC) *FOR %CC_D% = %CC_DRIV% *RUNALLOCATION *FACTOR = 1 *DIM ACCOUNT WHAT = AC_NONE; WHERE = 700998; USING = %CC_D% *DIM CC_SENDER WHAT = [POOL_DRIVER] = "%CC_D%" AND [CCATEGY] = "CSP"; WHERE = <<<; USING = CS_NONE *DIM COSTCENTRE WHAT = CC_NONE; WHERE = >>>; USING = [CCATEGY] = "NSP" *DIM AUDITID WHAT = T4_SEND; WHERE = T4_ALLOC_1; USING = DRIVER_VEHICLES *DIM ACT_TYPE WHAT = BAS(ALL_ACTTYPE); WHERE = <<<; USING = NO_ACTTYPE *ENDALLOCATION *NEXT *COMMIT

I need to be able to allocate back to the receiving costcentres based on the Driver account ID that is stored as a property i.e. POOL_DRIVER against each sending costcentre ID.

Wondering what could be done to improve performance of this script.

This does not seem to write back any values despite having the correct intersections.

Appreciate any pointers in the right direction.

thanks

Nilesh D