Competence Center: Human Capital Management

Modern HCM systems provide a stable foundation for personnel administration, payroll and time management. Besides managing employee data, these solutions provide a wealth of information and analysis. An increasing number of companies are opting for strategic reporting – and for very good reasons.

Allocating personnel costs to the organizational structure in a genuinely commensurate way, analyzing reasons for fluctuation in detail or automatically calculating accruals for each employee are crucial factors for corporate success today.

It is indeed due to these and many other issues that the operational reporting in your HCM system no longer suffices, as complex calculations must be carried out whilst taking into account time dependencies in a data warehouse. Conversely, strategic reporting with all relevant HCM metrics allows taking personnel-related decisions based on well-founded analyses. Only the use of a data warehouse system creates nonetheless the technical and organizational prerequisites for such reporting.

With our qHCM personnel reporting, you receive a productive reporting tool with an overview of your personnel metrics. qHCM uses a solution approach that has been standardized over many years, with numerous predefined metrics.
Being based on a package solution, however, qHCM allows making individual adjustments at any time and equips you for future enhancements.

Package classification was based on technical aspects relating to SAP ERP HCM. This allows a simple introduction to HR reporting with fast results and a finished reporting of basic metrics. At the same time, we attach great importance to the uniform definition of metrics and data comparability across packages.
qHCM-PA underlies all packages. Employee master data that is defined here for personnel reporting is used in all additional packages. Likewise, the corporate structure determined in qHCM-OM can serve as the basis for further reports.

Overview of our data warehouse packages

qHCM-PA (Personnel Administration)

The qHCM-PA includes all reports on number of employees, attendance and absence, as well as sick leave. For each employee, information from Personnel Administration infotypes is prepared in consideration of time dependencies. This allows personnel units to be assessed as a whole or focusing on specific features, such as the employee group.
The combination of all-day attendance and absence with PA data offers many additional assessment options. For example, you can exclude long-term sick employees from workforce reporting. This package also includes a sickness report.

qHCM-OM (Organization Management)

The qHCM-OM package allows mapping the corporate structure in reporting. This package breaks down all metrics in all packages into your organizational structure.
In addition, qHCM-OM provides an overview of your vacant positions, as well as a staff requirements report. In this way, for example, you can compare available and required staff.

qHCM-PT (Time Management)

Further to the all-day attendance and absence information from the qHCM-PA, this package provides intraday attendance and absence information, as well as balances from the time management cluster.

qHCM-PY (Payroll)

In addition to the revision data, the billing package also contains payroll results enriched with employee information (qHCM-PA data).

qHCM Fluctuation

The fluctuation reporting can be used to represent changes in the number of employees. The basic set of changes consists of the status-changing measures, but can be extended to any other attributes of the employee. A particular strength of this package is its ability to identify fluctuations, so that one month’s headcount changes match the employee headcount from the qHCM-PA package.

qHCM Accruals/Assets and Holiday Reporting

This package bundles holiday and overtime reports. It contains, among other things, metrics for holiday entitlement, remaining holiday time per employee and a comparison with accrued holiday for the provision calculation. All metrics are also calculated for forecast purposes for future holidays.
This package also provides the functionality to assess holiday and overtime calculations in monetary terms, and to generate accrual postings in SAP-FI.

Our modeling in detail

The use of our qHCM standard model guarantees a mature data model that has proven itself in daily use with different customers. You will benefit from our extensive project experience and various technologies that are used in our implementation projects. Examples listed below:

Delta mechanism

An implemented delta mechanism enables both the extraction of the data delta from the source system and the updating of said delta in the BW. This also allows intraday data loading!

In-periods and for-periods

The qHCM standard model is available in three different increments:

• Deadline view The deadline view contains only one snapshot view for each last day of the month plus the previous day status for the current month. Data from the past months will not be changed.
• For-periods The For-period view represents the mirror to the feeder system. All changes in the source system are thus considered. However, there are no fixed dates in this model (historically correct reporting).
• In-periods and for-periods As usual in billing processes, all data are booked on an accrual basis. As a result, both a view of the data that corresponds to the source system and a stable view of the data can be generated. In this way, reported data can be traced at any time (historically correct and historically stable reporting).

2-tier model

The implementation in a 2-tier model guarantees a solution that can be expanded with utmost flexibility, and which is also SAP HANA-ready. The reduction of tiers saves memory space and enables a more cost-efficient data model expansion.

Central logic

A centrally stored logic guarantees a highly maintainable system and enables the system-wide, uniform definition of metrics.