Transfer In

SET CREATENONMISSINGBLK ON;

VAR savedAction = 0;

FIX ([Scenario], [Version], [Employees],  [Department], [Year],  @LEVMBRS("Period", 0), "Local", "HSP_InputValue")
"Action"(
	IF  ("Fiscal TP-Index" == [Month]->"Fiscal TP-Index")
		"Action" = 8;
	ELSEIF  ("Fiscal TP-Index" < [Month]->"Fiscal TP-Index")
		"Action" = #MISSING;
	ELSE
		IF (savedAction <> 7 AND "Action" == 8)
			"Action" = #MISSING;
		ELSEIF ("Action" == 7)
			savedAction = 7;
		ENDIF		 
	ENDIF	
);
ENDFIX

FIX ([Scenario], [Version], [Employees],  [Department], [Year],  @LEVMBRS("Period", 0), "Local", "HSP_InputValue")
"Action" 
(	
	IF ([FTE] != #MISSING)
		"FTE" = [FTE];
	ENDIF;
	IF ([Position] != #MISSING)
		"Position" = [Position];
	ENDIF;
	IF ([Grade] != #MISSING)
		"Grade" = [Grade];
	ENDIF;
	IF ([TaxRegion] != #MISSING)
		"Tax Region" = [TaxRegion];
	ENDIF;
	IF ([EmployeeType] != #MISSING)
		"Employee Type" = [EmployeeType];
	ENDIF;
	IF ([HealthPlan] != #MISSING)
		"Health Plan" = [HealthPlan];
	ENDIF;
	IF ([MeritMonth] != #MISSING)
		"Merit Month" = [MeritMonth];
	ENDIF;
       IF ([SalaryBasis] != #MISSING)
		"Salary Basis" = [SalaryBasis];
		IF ("Salary Basis" == 2)
			"Hours per week" = [HoursPerWeek];
		ENDIF
	ENDIF;
	IF ([SalaryRate] != #MISSING)
		"Salary Rate" =  [SalaryRate];
	ENDIF;
	IF ([PayType] != #MISSING)
           "Pay Type" = [PayType];
       ENDIF;
	
);
CALC DIM ("Account");
ENDFIX