Human resources cube (HumanResourceCube) for Microsoft Dynamics AX 2012 R2 and R3

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

The Human resources cube for Microsoft Dynamics AX is used to analyze data for applicants, workers, positions, jobs, and courses. Analysis of human resources data is required for organizations to effectively manage their workforce and make decisions based on accurate information. This article provides details about the cube.

Note

This cube is available with cumulative update 7 for Microsoft Dynamics AX 2012 R2 and Microsoft Dynamics AX 2012 R3.

Deployment Configuration keys Tables and views Measures Calculated measures Key performance indicators Security

Analytics in Microsoft Dynamics AX Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3 Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack

Deployment

The Human resources cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX project—and the cubes that it contains—see Deploy the default cubes.

Configuration keys

The following configuration keys are required to use all features of the Human resources cube:

• Human resource I (HRMAdministration)

• Human resource II (HRMManagment)

• Human resource III (HRMCollaborative)

Tables and views

The Human resources cube uses data from the following tables and views:

• HcmBenefitOption table

• HcmBenefitPlan table

• HcmBenefitType table

• HcmJob table

• HcmPersonProfessionalExperience table

• HcmPersonProjectRole table

• HcmPersonTrustedPosition table

• HcmPosition table

• HcmPositionWorkerAssignment table

• HcmRatingModel table

• HcmSkillType table

• HRMApplication table

• HRMApplicationBasket table

• HRMCompFixedAction table

• HRMCompFixedEmpl table

• HRMCompFixedPlanTable table

• HRMCompPayFrequency table

• HRMCompVarAwardEmpl table

• HRMCompVarEnrollEmpl table

• HRMCompVarPlanTable table

• HRMCompVarPlanType table

• HRMCompVesting table

• HRMCourseTable table

• HRMMedia table

• HRMRecruitingTable table

• HcmApplicantCube view

• HcmCompetenciesCube view

• HcmCourseTypeCube view

• HcmDepartmentCube view

• HcmEmploymentCube view

• HcmEmploymentDetailCube view

• HcmEmploymentTurnOverCube view

• HcmJobCertificatesCube view

• HcmJobCube view

• HcmJobEducationDisciplineCube view

• HcmJobResponsibilityCube view

• HcmJobScreeningCube view

• HcmJobSkillsCube view

• HcmJobTaskAssignmentCube view

• HcmJobTestsCube view

• HcmPersonCertificateCube view

• HcmPersonDetailsCube view

• HcmPersonEducationCube view

• HcmPersonScreeningCube view

• HcmPersonSkillCube view

• HcmPersonTestsCube view

• HcmPositionDetailCube view

• HcmUnionAgreementCube view

• HcmWorkerEnrolledBenefitsCube view

• HRMCompFixedEmplCube view

• HRMCompVarAwardEmplCube view

• HRMCompVarEnrollEmplCube view

• HRMCourseAttendeeCube view

• HRMCourseInstructorCube view

• HRMRecruitingProjectCube view

Measures

The Human resources cube includes the following measure groups.

Fixed compensation

This measure group is based on the HRMCompFixedEmpl table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Fixed compensation count	Not applicable	Count	This measure is used in the calculated measure and is hidden from end users. See the Calculated measures section.	Company Fixed compensation Position Fixed compensation action Compensation pay frequency Compensation fixed plan Worker Date (effective date)

Variable compensation enrollment

This measure group is based on the HRMCompVarEnrollEmpl table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Variable compensation enrollment count	Not applicable	Count	This measure is used in the calculated measure and is hidden from end users. See the Calculated measures section.	Company Variable compensation enrollment Compensation variable plan Worker Date (effective date)

Variable compensation

This measure group is based on the HRMCompVarAwardEmpl table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Variable compensation count	Not applicable	Count	This measure is used in the calculated measure and is hidden from end users. See the Calculated measures section.	Company Compensation variable plan Compensation variable type Compensation vesting rules Compensation fixed plan Variable compensation Worker

Application basket

This measure group is based on the HRMApplicationBasket table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Application basket count	HRMApplicationBasket.HRMApplicantID	Count	The number of job applications in an application basket.	Company Recruitment projects

Applications

This measure group is based on the HRMApplication table and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of applications	HRMApplication.Applicant	Count	The number of job applications related to a recruitment project.	Company Job Applications Media Recruitment projects Applicant Departments Application and recruitment project cube Worker
Sum of travel cost	HRMApplication.TravelCostMST	Sum	The sum of Travel Cost on the Application form.
Sum of lodging cost	HRMApplication.LodgingCostMST	Sum	The sum of Lodging Cost on the Application form.
Sum of other cost	HRMApplication.OtherCostMST	Sum	The sum of Other Cost on the Application form.

Workers

This measure group is based on the HCMEmploymentCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Workers count	Not applicable	Count	See the Calculated measures section.	Company Position worker assignments Employment Employment details Jobs Departments Positions Union agreement Worker Date (employment end date) Date (assignment start date) Date (assignment end date) Date (leave start date) Date (leave end date) Date (employment start date) Worker (recruiter) Worker (hiring manager) Worker details
EmployeeServiceLength0to5	HCMEmploymentCube.EmployeeServiceLength0To5	Sum
EmployeeServiceLength11to15	HCMEmploymentCube.EmployeeServiceLength11To15	Sum
EmployeeServiceLength6to10	HCMEmploymentCube.EmployeeServiceLength6To10	Sum
EmployeeServiceLengthMoreThan15	HCMEmploymentCube.EmployeeServiceLengthMoreThan15	Sum
LengthOfService	HCMEmploymentCube.LengthOfService	Sum
IsEmployeeActive	HCMEmploymentCube.IsEmployeeActive	Sum
Count of employee leaves	HCMEmploymentCube.HCMEmploymentLeaveRecID	Count

Employment turnover

This measure group is based on the HCMEmploymentTurnoverCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Employment turnover count	Not applicable	Count	See the Calculated measures section.	Company Worker Date (employment end date) Worker (recruiter) Worker (hiring manager)
Employment turnover count of workers	HCMEmploymentTurnoverCube.Worker	Distinct count

Job - certificates

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobCertificatesCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of certificates	HCMJobCertificatesCube.HCMJobPreferredCertificateRecID	Distinct count	The number of certificates for a job. For details, see the Certificates tab on the Job Details form.	Job - certificates Jobs

Competencies

This measure group is based on the HCMCompetenciesCube view, HCMPersonScreeningCube view, HCMPersonTestsCube view, HCMPersonCertificateCube view, HCMPersonEducationCube view, and HCMPersonSkillCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of workers	HCMCompetenciesCube.Worker	Distinct count	The number of workers having competencies as defined on the Competencies tab of the Worker list page.	Company Professional experience Project experience Position of trust Rating models Skill type Courses Applicant Certificates Education Screenings Skills Tests Worker
Count of applicants	HCMCompetenciesCube.Applicant	Count	The number of applicants having competencies as defined on the Competencies tab of the Applicants list page.

Job - education

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobEducationDisciplineCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of education disciplines	HCMJobEducationDisciplineCube.HCMJobPreferredEducationDisciplineRecID	Distinct count	The job details that cover the Education FastTab for a job.	Jobs Job - education

Job – areas of responsibility

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobResponsibilityCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of responsibilities	HCMJobResponsibilityCube.HCMJobResponsibilityRecID	Distinct count	The number of areas of responsibility for a job. For details, see the Areas of Responsibility tab in the Job Details form.	Jobs Job – areas of responsibility

Job - screening

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobScreeningCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of screenings	HCMJobScreeningCube.HCMJobScreeningRecID	Distinct count	The number of screenings for a job. For details, see the Screenings tab in the Job Details form.	Jobs Job - screening

Job - skills

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobSkillsCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of skills	HCMJobSkillsCube.HCMJobPreferredRecID	Distinct count	The number of skills for a job. For details, see the Skills tab in the Job Details form.	Jobs Job - skills

Job – work tasks

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobTasksCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of task assignments	HCMJobTaskAssignmentCube.HCMJobTaskAssignmentRecID	Distinct count	The number of job tasks associated with a job. For details, see the Job Tasks tab of the Job Details form.	Job Jobs Job – work tasks

Job - Tests

This measure group is based on the HCMCompetenciesCube view, HCMApplicantCube view, and HCMJobTestsCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of tests	HCMJobTestsCube.HCMJobPreferredExamRedID	Distinct count	The number of tests for a job. For details, see the Tests tab of the Job Details form.	Jobs Job - tests

Worker enrolled benefits

This measure group is based on the HCMWorkerEnrolledBenefitsCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Number of benefit enrollments	HCMWorkerEnrolledBenefitsCube.HCMWorkerEnrolledBenefitRecID	Distinct count	The number of benefit enrollments, so that you can analyze which workers are associated with which benefits.	Benefit plan Benefit option Benefit type Jobs Positions Union agreement Worker enrolled benefits Worker Date (worker enrolled benefit valid from) Date (worker enrolled benefit valid to)

Employee fixed compensation

This measure group is based on the HRMComFixedEmplCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Employee fixed compensation count	Not applicable	Count	See the Calculated measures section.	Company Fixed compensation Position Fixed compensation action Compensation pay frequency Compensation fixed plan Jobs Positions Union agreement Employee fixed compensation Worker Date (effective date) Date (employment end date)
Increase amount	HRMCompFixedEmplCube.IncreaseAmount	Sum
Increase percent	HRMCompFixedEmplCube.IncreasePercent	Sum
Pay rate	HRMCompFixedEmplCube.PayRate	Sum

Employee variable compensation

This measure group is based on the HRMCompVarAwardEmplCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Employee variable compensation count	Not applicable	Count	See the Calculated measures section.	Company Compensation variable plan Compensation variable type Compensation vesting rules Compensation fixed plan Variable compensation Jobs Positions Union agreement Employee variable compensation Worker Date (award date)
Number of units	HRMCompVarAwardEmplCube.Units	Sum	This measure is used in the calculated measure and is hidden from end users. See the Calculated measures section.
Unit value	HRMCompVarAwardEmplCube.UnitValue	Sum	This measure is used in the calculated measure and is hidden from end users. See the Calculated measures section.

Employee variable compensation enrollment

This measure group is based on the HRMCompVarEnrollEmplCube view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Employee variable compensation enrollment count	Not applicable	Count	See the Calculated measures section.	Company Variable compensation enrollment Compensation variable plan Jobs Departments Positions Union agreement Employee variable compensation enrollment Worker Date (effective date) Date (employment end date)
Award amount	HRMCompVarEnrollEmplCube.AwardAmount	Sum
Award percent	HRMCompVarEnrollEmplCube.AwardPercent	Sum
Organization percentage	HRMCompVarEnrollEmplCube.OrganizationPercent	Sum

Course participants

This measure group is based on the HCMCourseTypeCube view, HRMCourseAttendeeCube view, HRMCourseInstructorCube view and includes the following measures. See also the Calculated measures section for calculated measures in this measure group.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Count of participants with training status	HRMCourseAttendeeCube.CourseAtteddeID	Distinct count	The number of participants that are related to a course.	Company Courses Course type and group Course participants Course instructors Date (course end date) Date (course start date)

Recruitment projects

This measure group is based on the HRMApplicationRecruitmentProjectCube view, HCMPositionDetailCube view, and HCMJobCube view and includes the following measure. See also the Calculated measures section for calculated measures in this measure group.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Recruitment projects count	Not applicable	Count	The number of applicants whose applications have a status of employed and an application start date in the time period specified.	Company Job Applications Media Recruitment projects Jobs Applicant Departments Positions Union agreement Application and recruitment project cube Worker Date (effective date) Date (employment end date) Worker (recruiter) Worker (hiring manager) Date (applicant employment start date)
Applicants hired count	HRMRecruitingProjectCube.HRMApplicationID	Distinct count	The number of applicants whose applications have a status of employed and an application start date in the time period specified.
RecruitingDays	HRMRecruitingProjectCube.RecruitingDays	Sum	This measure is used in the calculated measure and is hidden from end users. See the Calculated measures section.

Calculated measures

The Human resources cube contains the following calculated measures.

Calculated measure	Aggregation	Associated measure group	Description
Average days to recruit	Number of days from the open date of the recruitment project to the start date of the application for one record. This number is then calculated for all records and added together, and then divided by the number of records.	Recruitment projects	All applications that have a status of Employed and have a start date in the time period that is specified are included. This calculated measure uses the Open Date field from the recruitment project and the Start Date field from the application to find the number of days to recruit for each record in the timeframe. The numbers are added for all records and then divided by the number of records. The calculation excludes records that do not have an Open Date and applications without a recruitment project. The most frequently used dimensions associated with this calculated measure are the following: Recruiter, Department, Hiring manager, Media source, Recruitment projects, Interviewer, Applications, Applicant, Positions, and Jobs.
Percentage of participants with confirmation training status	Number of participants with Confirmation training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who have been confirmed for the course. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Percentage of participants with completed training status	Number of participants with Completed training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who have completed the course. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Percentage of participants with passed training status	Number of participants with Passed training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who have passed the course. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Percentage of participants with waiting list training status	Number of participants with Waiting List training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who are on the waiting list for the course. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Percentage of participants with canceled training status	Number of participants with Canceled training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who have canceled. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Percentage of participants with dropout training status	Number of participants with Dropout training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who have dropped out of the course. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Percentage of participants with registered training status	Number of participants with Registered training status divided by total number of participants related to any course.	Course participants	Defines the percentage of course participants who have registered for the course. The most frequently used dimensions associated with this calculated measure are the following: Courses, Course type and group, Course participants, Course instructors, Course start date, and Course end date.
Number of months of service for a worker	Length of service divided by count of workers.	Workers	Defines seniority at the organization. The most frequently used dimensions associated with this calculated measure are the following: Worker, Department, Company, and Is employment detail active.
Workers with years of service 0-5 count	Number of workers whose length of service is greater than 0 years and less than 6 years.	Workers	Defines seniority at the organization. The most frequently used dimensions associated with this calculated measure are the following: Worker, Department, Company, Is position detail active, Is position worker assignment active, Is position assigned, and Is employment detail active.
Workers with years of service 6-10 count	Number of workers whose length of service is greater than 5 years and less than 11 years.	Workers	Defines seniority at the organization. The most frequently used dimensions associated with this calculated measure are the following: Worker, Department, Company, Is position detail active, Is position worker assignment active, Is position assigned, and Is employment detail active.
Workers with years of service 11-15 count	Number of workers whose length of service is greater than 10 years and less than 16 years.	Workers	Defines seniority at the organization. The most frequently used dimensions associated with this calculated measure are the following: Worker, Department, Company, Is position detail active, Is position worker assignment active, Is position assigned, and Is employment detail active.
Workers with more than 15 years of service count	Number of workers whose length of service is greater than or equal to 15 years.	Workers	Defines seniority at the organization. The most frequently used dimensions associated with this calculated measure are the following: Worker, Department, Company, Is position detail active, Is position worker assignment active, Is position assigned, and Is employment detail active.
Number of workers	Sum of workers with the condition below: If workers count is greater than zero, then return 1 or return the workers count.	Workers	Defines the total number of workers in the Workers form. The most frequently used dimensions associated with this calculated measure are the following: Worker, Positions, Departments, Company, Is employment detail active, and Is position detail active.
Number of workers terminated	Sum of workers with the condition below: If workers count is greater than zero and employment is not active, then return 1 or return null.	Workers	Defines the total number of workers terminated. The most frequently used dimensions associated with this calculated measure are the following: Worker, Positions, Departments, Company, Is employment detail active, and Is position detail active.
Number of position assignments	Sum of position worker assignments.	Workers	Defines the total number of position assignments. The most frequently used dimensions associated with this calculated measure are the following: Worker, Positions, Departments, Company, Is employment detail active, and Is position detail active.
Sum of increase amount	Sum of the Increase Amount field in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Average of increase amount	Sum of the Increase Amount field divided by the total number of records in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Average of increase percentage	Sum of the Increase Percent field divided by the total number of records in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Sum of annual equivalent	Sum of the Annual Equivalent field in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Average of annual equivalent	Sum of Annual Equivalent field divided by the total number of records in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Sum of units	Sum of the Number of Units field in the Employee Variable Compensation Awards form.	Employee variable compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation, Compensation variable plan, and Worker.
Sum of unit value	Sum of the Unit Value field in the Employee Variable Compensation Awards form.	Employee variable compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation, Compensation variable plan, and Worker.
Average of units	Sum of the number of units divided by the total number of records in the Employee Variable Compensation Awards form.	Employee variable compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation, Compensation variable plan, and Worker.
Average of unit value	Sum of the Unit Value field divided by the total number of records in the Employee Variable Compensation Awards form.	Employee variable compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation, Compensation variable plan, and Worker.
Sum of award amount	Sum of the Award Amount field in the Employee Variable Compensation Enrollment form.	Employee variable compensation enrollment	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation enrollment, Compensation variable plan, and Worker.
Average of award amount	Sum of the Award Amount field divided by the total number of records in the Employee Variable Compensation Enrollment form.	Employee variable compensation enrollment	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation enrollment, Compensation variable plan, and Worker.
Average of award percentage	Sum of the Award Percent field divided by the total number of records in the Employee Variable Compensation Enrollment form.	Employee variable compensation enrollment	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation enrollment, Compensation variable plan, and Worker.
Average of organization percentage	Sum of the Percent field divided by the total number of records in the Employee Variable Compensation Enrollment form.	Employee variable compensation enrollment	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee variable compensation enrollment, Compensation variable plan, and Worker.
Sum of monthly equivalent	Sum of the Monthly Equivalent field in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Sum of hourly equivalent	Sum of the Hourly Equivalent field in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Average of monthly equivalent	Sum of the Monthly Equivalent field divided by the total number of records in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Average of hourly equivalent	Sum of the Hourly Equivalent field divided by the total number of records in the Employee Fixed Compensation form.	Employee fixed compensation	The most frequently used dimensions associated with this calculated measure are the following: Company, Employee fixed compensation, Compensation fixed plan, and Worker.
Employee fixed compensation distinct count	Count	Employee fixed compensation	This calculated measure is hidden to end users. It is used in other calculations.
Workers on leave count	Number of workers with a leave start and end date. Specifying a time range is optional.	Workers	Defines employment leaves at the organization. The most frequently used dimensions associated with this calculated measure are the following: Worker, Leave start date, Leave end date, and Company.
Number of employments	The number of employments of workers, it sums all of the employments of workers in different legal entities.	Workers	Define the total number of worker employments. The most frequently used dimensions associated with this calculated measure are the following: Worker, Positions, Departments, Company, Is employment detail active, and Is position detail active.
Employment turnover rate	Total number of employees terminated in the time period, divided by the average number of employees in the time period, then multiplied by 100. (The average number of employees in the time period is calculated as: number of employees at the start of the time period, plus the number of employees at the end of the time period, divided by two.)	Employment turnover	The most frequently used dimensions associated with this calculated measure are the following: Company, Employment end date, and Worker.
Number of hired workers	Total number of workers hired in any legal entity.	Employment turnover	The most frequently used dimensions associated with this calculated measure are the following: Company, Employment end date, and Worker.
Number of active workers	Total number of workers that have an active employment in any legal entity.	Employment turnover	The most frequently used dimensions associated with this calculated measure are the following: Company, Employment end date, and Worker.
Number of active workers - local	Count	Employment turnover	This calculated measure is hidden to end users. It is used in other calculations.
Number of workers terminated - local	Count	Workers	This calculated measure is hidden to end users. It is used in other calculations.

Key performance indicators

The Human resources cube does not include any key performance indicators (KPIs).

Security

The Human resources cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.

• Chief financial officer

• Compensation and benefits manager

• Human resource assistant

• Human resource manager

• Manager

• Recruiter

• Training manager