Human Resource (HR) policies state an expense should not be…
Human Resource (HR) policies state an expense should not be reimbursed more than once. However, employees may try and get the same expense reimbursed twice. For example, an employee may submit for reimbursement the cost of an airline ticket (Airline Ticket Number) before the flight and then will submit the same airline ticket number for reimbursement after the flight. The Senior Internal Auditor informs you that one possible way of solving the following question includes duplicating the “Airline Ticket Number” dimension and to convert that duplicate into a measure and to avoid using a distinct count. Which employee number had an airline ticket reimbursed twice (i.e., at least twice)? (only use the last 5 digits of the employee number, e.g., EE073125 would be entered as 73125).