Which HR KF ? Cumulative/NonCumulative (Aggregation Type= "SUM", "Last Day)

[Former Member]

Hello all,

For planning at Headcount Level, I was wondering which KF should be used ?

1) Headcount FTE 0HDCNT_FTE (Cumulative)

2) Headcount FTE 0HDFTE_NC (NonCumulative)

Note that 0HDCNT_FTE is of Aggregation Type = "SUM", "Last Day".

I was wondering if anyone has used the cumulative (0HDCNT_FTE) in a Transactional Cube ? Are there any problems with these ?

Any feedback would be most appreciated!

[Former Member]

Hi,

If you are using the head count KF (0HDCNT_FTE) as cumulative then the Number of employess(Head Count) wont be matching at any time.

Eg: Let today the KY value is 1 employees

Tommrow if one more guy joine the new Count will be 2

Now if you go for cumulative sum, it will be 1+2 = 3

Hope you got it.

Regards

Happy Tony

[Former Member]

Thanks for your reply Toni. But Headcount FTE is always 1 for regular employees. This means that both employees will have Headcount FTE = 1. Sum will be 2. This will be correct.

I am more interested in BPS Planning aspects: is there any impact on the delta records stored in the Transactional (Real Time) cube ?