Question Re: Proportional monthly FTE headcount in Technology Q&A

Proportional monthly FTE headcount

Former Member — Thu, 18 Oct 2012 08:05:13 GMT

Hi friends,

One of the requirements customer asks is a proportional FTE headcount depending on how many days employee has worked an specific month. It means, if employee has worked the full month, FTE count would be 1 (or 100%), but if for example on the 15th he has changed role, moved, etc, FTE count should be the proportional to the month (30days month then 0,5 or 50%, 31days month then 0,48 or 48%).

Another problem I have to get this solved is that I need BEGDA and ENDDA (so 0DATEFROM and 0DATETO) to calculate it, and as most of data I'm using is master data from 0EMPLOYEE, these data are missed at 0EMPLOYEE level even if it's been extracted at PSA level. (Can anyone explain me why these data disappear when reaches attr infosource level?)

I've seen there might be something Standard already included in InfoCube 0PAPA_C02 and InfoSource / DataSource 0HR_PA_PA1, but it's not solving my problem.

I've checked in help.sap :http://help.sap.com/saphelp_nw04/helpdata/EN/46/2fa63a2c2b3b48e10000000a11402f/frameset.htm

and I've checked also SAP note: 336229 , but this note refers to BI versions 2.1C and 3.0 .I'm using BI version 7 and datasource has not been activated and installed automatically from Business Content.

Any tip or kind of help will be more than welcome!?

Thanks a lot!

Alberto

Re: Proportional monthly FTE headcount

Former Member — Thu, 18 Oct 2012 15:37:56 GMT

do u guys keep data in catsDB table for employee hours? if you do that , then thats where you will get head count of how many employees worked that month on how many days..

Re: Proportional monthly FTE headcount

Former Member — Mon, 22 Oct 2012 07:10:36 GMT

Hi Amer,

I'm not aware about these tables.

The question is that I already have days employee has worked with 0DATETO and 0DATEFROM. For example:

0DATETO: 06.10.2012 , it means that employee has worked 6 days on October. If he had worked 31 day, FTE count would be 1, but working just 6, FTE count would be 0,19.

Problem is that I have 0DATETO and 0DATEFROM in 0EMPLOYEE_attr extractor, but these characteristics don't appear any more at infosource level, consequently, nor in 0EMPLOYEE, so I cannot work with them.

Any help?

Re: Proportional monthly FTE headcount

Former Member — Mon, 22 Oct 2012 09:42:07 GMT

hi,

iam sure you will have date to and date from in 0employee infoobject try creating a transformation you will find it or add date from and date to as attributes and map them to enda and begda respectively.

please note you need to load some 4 extractors to 0employe which will give certain level of information like person etc

Thanks

Krishna

Re: Proportional monthly FTE headcount

Former Member — Mon, 22 Oct 2012 09:42:46 GMT

hi,

please note you need to load some 4 extractors to 0employe which will give certain level of information like person etc

Thanks

Krishna

Re: Proportional monthly FTE headcount

Former Member — Mon, 22 Oct 2012 17:49:11 GMT

Modify your infosource and include the char 0dateto and 0datefrom and also modify the same in 0employee.

Then map these fields in the transfer rules or transformation and load the data

You will be good to go after this

Cheers!