Skip to Content
author's profile photo Former Member
Former Member

Query on HR Head count report

Hi Experts,

I have an issue with regarding HR Headcount report. Requesting some one to help on this.

Problem statement:

We have built a BEX report on HR Cube to get the Head count report. When we run the report for a particular year/quarter/period, we were able to get the latest head count of that particular selection.

But when an employee has transferred from one department to another department, we are able to find two entries for that employee one with old department and other with latest department.

Below is the report when we run the report for the FY 2017

EmployeeID Department FiscalPeriod HeadCount

100001 Accounting 1.2017 1

100001 Sales 9.2017 1

Ideally we should get the second entry as it is the latest entry of an employee.

Kindly suggest how to resolve this issue.

Thanks in advance.

Best Regards,

Krish.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2017 at 04:48 AM

    But when we run the report only with employeeID as the selection we are able to get single entry as below.

    EmployeeID HeadCount

    100001 1

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.