Hi,
Couple of questions on the script logic below
1) Doesn't the system look for the "Year" property in the "category" dimension where I used %YEAR%.INP in the script below? Year property in the category that I selected has 2016, but the script below is using 2017.INP.
2) The below script works fine with *FOR/*NEXT. If I remove *FOR/*NEXT logic to improve the performance and replace the row containing Time dimension to the line below, it is summing up the values for 2016.01, 2016.02, 2016.03.... and posting the summed number in each months. Do you know how this can be corrected?
*DIM TIME WHAT = %TIME_SET%; WHERE = <<<; USING = %YEAR%.INP;
*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET EMPLOYEE = BAS(EXISTING_EMP)
*XDIM_MEMBERSET COSTCENTER = %COSTCENTER_SET%
*XDIM_MEMBERSET HC_LOCATION = %HC_LOCATION_SET%
*XDIM_MEMBERSET HC_COMPANY = %HC_COMPANY_SET%
*XDIM_MEMBERSET HC_POSITION = %HC_POSITION_SET%
*XDIM_MEMBERSET AUDITTRAIL = INPUT,HC_CALC,WORKDAY
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET HC_ACCOUNT = SPREAD_YEAR,SALARIES_FTE,SALARIES_ANNUAL
*FOR %TIM%=%TIME_SET%
*RUNALLOCATION
*FACTOR = USING
*DIM AUDITTRAIL WHAT = INPUT; WHERE = HC_CALC; USING = WORKDAY;
*DIM COSTCENTER WHAT = CC_NONE; WHERE = %COSTCENTER_SET%; USING = <<<;
*DIM EMPLOYEE WHAT = NO_EMP; WHERE = BAS(EXISTING_EMP); USING = <<<;
*DIM HC_ACCOUNT WHAT = SPREAD_YEAR; WHERE = SALARIES_FTE; USING = SALARIES_ANNUAL;
*DIM HC_COMPANY WHAT = E_1000; WHERE = BAS(ALL_COMPANY); USING = <<<;
*DIM HC_LOCATION WHAT = BAS(L_ALL); WHERE = <<<; USING = <<<;
*DIM HC_POSITION WHAT = CG_NA; WHERE = %HC_POSITION_SET%; USING = <<<;
*DIM HC_STATUS WHAT = FTE_EXISTING; WHERE = BAS(FTE_EXIST_TOT); USING = <<<;
*DIM RPTCURRENCY WHAT = LC; WHERE = <<<; USING = <<<;
*DIM TIME WHAT = %TIM%; WHERE = <<<; USING = %YEAR%.INP;
*ENDALLOCATION
*NEXT