Skip to Content
avatar image
Former Member

key date selection in BW-Bex query

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 06, 2017 at 09:42 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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)