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