on 05-24-2011 10:32 AM
Hi,
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?
Thanks
You need to review how to make the query function on a time dependent basis. the "Key Date" of the query is usually what activates this, and ensure the organization is also time dependent (it is by default).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
If you have end date for current positions maintained as 31/12/9999 , try restricting the keyfigures on end date = 31/12/9999 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.