on 06-06-2017 9:57 AM
Hi,
Please help me to create a end routine where I get the data as per key date..
The issue is headcount is showing wrong in report it is due to employee location is changing showing in.. suppose A employee record in 20011 in X location and in 2012 Y location 2013 in Z location and for B employee in 20011 in X location and in 2012 Y location 2013 in Z location ..that's why headcount is not showing right ..please get me the logic for latest key date instance data.
Regards,
Thanks a lot Karthik,
Yes we need to pick the active employee..please advise whether in Bex or in End routine to get that.
Irrespective of movement (transfer between location), the bex should be able to fetch the active employees as on date. All active users will have an To date as 31.12.9999
For example right now report is fetching data in bex as below :
Emp No Name Plant Calendar Day FTE _Count
1334000143 raman AB 01.01.2014 1
10.10.2014 1
01.01.2016 1
hence total headcount is showing 3 for AB ..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I missed some information.Here in your question which is showing wrong.Is that 1)Total headcount or 2) Active employee headcount which one you want to show at report level.If it is active employee headcount as on date then In the selection screen keep the condition on start data is less than system data and enddate is grater than system date by creating customer exit variable (not ready for input).
Regards,
KK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.