Skip to Content
0
Former Member
Jan 18, 2011 at 01:02 AM

Cost center Allocation in NW

35 Views

Hello All,

I have an issue allocating the Fringe to the costcenters in NW version.

I am trying to allocated amount(10,000) from costcenter US0170001, to

all other costcenters which has property value allocationce="US" by headcount STATHC.

EX: if Headcount(acct:stathc) in costcenter CC1 is 100 and total headcount of all coscenters is 1000 then

CC1 shoud have 10,000* 100/1000. I really appreciate your help ASAP.

Trying to run for cost centers.Script is running with out writing the records. Following is the syntax.

*XDIM_MEMBERSET P_ACCOUNT=EXP008,STATHC

*XDIM_MEMBERSET PENTITY=US01

*XDIM_MEMBERSET P_DATASRC=MANUAL

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET COSTCTR=US0170001,US0110000,US0120000

*XDIM_MEMBERSET CATEGORY=FORECAST

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM P_ACCOUNT WHAT=EXP008; WHERE=<<<; USING=STATHC; TOTAL=<<<

*DIM PENTITY WHAT=US01; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM COSTCTR WHAT=US0170001;WHERE=US0110000,US0120000;USING=<<<;TOTAL=<<<

*ENDALLOCATION

*COMMIT

following is last lines of the log:

Merge WHAT and USING

--Time to merge WHAT and USING :0.00014 second(s).

-


--Apply factor

[P_ACCOUNT] =STATHC

[COSTCTR] =US0110000,US0120000

[P_DATASRC] =MANUAL

[RPTCURRENCY] =LC

[CATEGORY] =FORECAST

[PENTITY] =US01

WHERE=WHAT *USING/TOTAL

--Time to apply factor :0.339085 second(s).

-


--Read destination and calculate difference

[P_ACCOUNT] =EXP008

[COSTCTR] =US0110000,US0120000

[P_DATASRC] =MANUAL

[RPTCURRENCY] =LC

[CATEGORY] =FORECAST

[PENTITY] =US01

--Time to read destination and calculate difference :0.429936 second(s).

-


--Records succeeded to write back 🤯

-


--Time to run Allocation :1.52351 second(s).D=412

Regards,

Saila