Skip to Content
0

key date selection in BW-Bex query

Jun 06, 2017 at 08:57 AM

149

avatar image
Former Member

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jun 06, 2017 at 09:10 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jun 06, 2017 at 09:42 AM
0

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 ..

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I think no end routine is required for the above requirement. Looks like Keyfigure FTE_count has set to summation.Change it to Exception aggregation Last value. with the above logic(start date <= sysdate and enddate >= sysdate.Hope this can solbe your problem.

Regards,

KK

0
Former Member

I tried it to change the exception aggregation to last but it seems not worked ..

FTE_Count is FTE value which is having standard aggregation (Delegate measure coming from rule details(Endroutine).

below the screenshot for the report record and designer :

Please help

Thanks in advance..

headcount-issue.jpg (141.4 kB)
0