Skip to Content
0
Former Member
Feb 10, 2009 at 01:57 PM

HR Report in BI for Headcount Turnover & Retention Report

354 Views

Hi Gurus,

I need to create HR Report in Bex Analyser. The report is "Headcount Turnover & retention Report".

Report columns are:

Cost Center name || Headcount as of 1/1/09 || Num of New Hires (YTD) || Number of Terms YTD || Num of terms that were active on 1/1/09 (YTD) || Turnover % || Retention %

Where Turnover % is calculated bydividing total terms over total current headcount.

Where Retention % is dividing the number of those termed YTD who were active on 1/1/09 those were active on 1/1/09.

Headcound = Active employees(1/1/1900 to 1/1/2009).

New Hires = Newly hired after 1/1/09

Terms = who leaves company after 1/1/09.

I Created four restricted keyfigures

1).Headcount as of 1/1/09 with ( Number of employess, Calander day (1/1/1900 - 1/1/1009), Employee status [ Active]).

2).Num of New Hires with (Number of Actions, Calander day (1/1/2009 - Current Calander day variable),

Action type [New Hire]).

3).Number of Terms with ( Number of Actions, Calander day (1/1/2009 - Current Calander day variable),

Action Reason [ Leaving]).

4).No.of terms that were active on 1/1/09 with (number of Actions, Calander day (1/1/09), Action Reason (Leaving), Action Type (Active)).

In my result it is displaying all as active employess and i didn't see any terms. For headcount it is displaying multiple times for one employee. One employee should have only 1 in every field. But each employee having like 9, 17, 25.....etc. I checked in BI side there in cube content each employee has '1' in all fields. I don't know why it is taking multiple times.

Please can any one help me on this. Sorry for such a very long mail.

Thanks,

Aparna.

Edited by: Aparna Pyeddu on Feb 10, 2009 2:57 PM