Skip to Content
0

Query on HR Head count report

Dec 08, 2017 at 03:29 AM

22

avatar image
Former Member

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.

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

1 Answer

avatar image
Former Member Dec 08, 2017 at 04:48 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded