cancel
Showing results for 
Search instead for 
Did you mean: 

a cube to calculate the number of employees by each month end

Former Member
0 Kudos

how to create a cube to calculate the number of employees by each month end? Let's say, one company has 30000 employees. It means that one employee has 12 records one year. So, this cube has 30000*12=360000 records, that was very big.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

hi experts could you please explain me what is an Infopackage

Former Member
0 Kudos

e.g in cube 0PA_C01 we can see employee nr. 1

0calday--0HDCNT_LAST

2004-1-31--1

2004-2-29--1

2004-3-31--1

2004-4-30--1

2004-5-31--1

2004-6-30--1

2004-7-31--1

2004-8-31--1

2004-9-30--1

2004-10-31--1

2004-11-30--1

2004-12-31--1

so , in this case if one company has 30000 employees, the records will be very big in this cube

Former Member
0 Kudos

using cube 0PA_C01 (only use datasource 0HR_PA_0), KF (cumulative key figure) 0HDCNT_LAST, after loading transaction data I can see one employee has 12 records within one year. It means that cube 0PA_C01 calculate the number of employees by each employee by month. Actually we need this infomation with reference to the 0employee attr. however we worry about the records occurs in the cube. That will biger and biger.

e.g. with reference to the 0employee attr. use employee group, based on employee group I can distinguish how many person has attendance by each month by year. So, cube 0PA_C01 will calculate it.

Edited by: hi ni on May 10, 2008 12:20 PM

Former Member
0 Kudos

Hi

Head Count key figure in HR is non cumulative key figure..It won't cumulate data against date...So it will take care of this..You don't need to worry about this...

Thanks

Teja