restrict employee postion to current based on Org Unit
We have recently implemented structural Authorization and I am now trying to create a query based on Org Unit.
The query is to show employee by position based on org unit. I have made org unit auth relevant and created a hierarchy variable as the restriction. In the row/columns I have included Org unit with hierarchy activated, position and employee. The KF is Actual time.
When I execute the report it is bringing leavers and people in old positions. To remove leavers I included a restriction on person to remove anyone in the position 99999999.
But this is still showing people in old postions. These positions have been end dated in the system and current positions have date 31/12/9999.
Does anyone know how I can restrict position to only show current positions?