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.
.png "Reference")
Deployment Configuration keys Tables and views Measures Calculated measures Key performance indicators Security |
.png "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