Skip to Content
Former Member
May 11, 2013 at 04:53 AM

Employee Aging Analysis



Requirement is to calculate the length of service of an employee (Current date - Date of Joining) and show the no.of employees(count) pertaining to various age buckets for ex. length of Service < 1 year , 1 to 5 years, 5 to 10 years etc.

Header 1 Header 2 Header 2 Header 3 Header 4 Person Area Person Sub area emp.code and name Age < 1 year 1 to 5 years etc A A1 E001 1 0 After droping Employee code Person Area Person Sub area Age < 1 year 1 to 5 years etc A A1 X

Characteristics required for analysis are Person Area, Person Sub area, Employee code and name.In columns query should show various age buckets as mentioned above.At the intersection of Row and Column I need no.of employee figure.

For above requirement I used 0employee master Info object in a query and calculated length of service using replacement path in query designer.I could see the age buckets and count 1 at each employee code level(Row).However If i drop employee code It will show nothing (x) in age buckets.

Why this happening if I remove employee characteristics?