다음을 통해 공유


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.

Reference

Deployment

Configuration keys

Tables and views

Measures

Calculated measures

Key performance indicators

Security

Resources

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