CubeServ HR Analytics

HR management
Rainer Sigg
Geschäftsleitung Deutschland

Human Resources in change

Classic HR management is undergoing change. New entities such as Business Partners, Share Service Centers (HR SSC) and Centers of Excellence (CoE) are emerging. Processes are shared and optimised, and existing jobs titles and professional roles are changing … and the HR IT?

What contribution can the HR application landscape make in providing the best possible support to the organisation and to processes in order to smooth the path to excellence?

Operative process support using ERP software from suppliers such as SAP with modules for payroll and HR management has been a constant in the HR IT landscape for decades. Reports and key figures are (used to be) generated directly from the operative data inventories.


Mit dem Laden des Videos akzeptieren Sie die Datenschutzerklärung von YouTube.
Mehr erfahren

Video laden

CubeServ Business Content for HR BW

Over recent years, we have found that the analytical aspects of HR data evaluation are becoming increasingly important. HR-related issues and tasks, such as demographic change, aging (of the population), the skills shortage, talent scouting, staff retention, diversification, occupational health management, demand new tools, applications and means to make the HR data available for viewing and analysis.

Additional requirements, such as visualisation, transparency and mobile workplaces/resources for staff and management extend the focus beyond list displays of key figures.

This is where the Business Warehouse systems (BW) and Business Intelligence (BI) applications from CubeServ with their specialist business content for HR come in.

Your benefits:

  • differentiation/enhancement with respect to the standard SAP content for HR
  • ready-made layer model for NetWeaver BW – also available for SAP BW on HANA
  • modular and scalable best-practice solution
  • solutions for HR-specific issues included
  • ready-made reports and portal content available for immediate use
  • pre-configured fixed-price packages, applicability guaranteed
  • no follow-up costs (maintenance/licences)

Best Practise at a fixed price

Our BW content has been developed with the aid of information about the business and technological requirements for data analysis in the HR environment gained from numerous HR-BW projects, producing the “best practice” approach at a fixed price.

CubeServ Business Content for HR comprises 4 different modules, based on the 4 core modules of SAP ERP Human Capital Management Software:

  • Personnel Administration (PA)
  • Organizational Management (OM)
  • Personnel Time Management (PT)
  • Payroll (PY)

In addition, the CubeServ Content covers special technical features of HR data, such as

  • the display of time series analyses in a hierarchy that is stable over time
  • view/derivation of all characteristics/key figures for specific key dates
  • stable (frozen) and corrected data views of retrospective changes to the source data (historically correct, historically stable)
  • movement/change analyses within/outside the company
  • FICO views of payroll data (For-Period/In-Period, incl. G/L account details)
  • indirect evaluation of wage types in conjunction with data extraction from the source
  • display of headcount key figures in forecast scenarios (e.g. EOY evaluation)
  • position and staffing management

It is a modular application with options to enhance and extend the individual modules and combine them with each other. This modular approach also allows customer-specific enhancements to be integrated without any problems in the form of Z-tables or 9xx infotypes – comparable to the infotype enhancements in the SAP Standard.

In addition to the modules mentioned above, our HR Content also includes a module for „CubeServ HR Personnel Cost Planning“ erhältlich.

Four modules, one application

Module “Personnel Administration (PA)”

Personnel Administration (PA) represents the core module of the BW application. For analysis purposes, data providers are made available for Headcount (Actual/Forecast), Measures (Actual/Forecast) and Personnel Change Analysis (Actual/Forecast). This content provides the technical and content basis for your reporting. It is based on the most important infotypes of the SAP HCM modules and – where useful – the SAP standard extractors.

  • IT0001 Organizational Assignment (incl. organizational hierarchy)
  • IT0002 Personal Data
  • IT0007 Planned Working Time
  • IT0008 Basic Pay
  • IT0014 Recurrent Payments/Deductions
  • IT0015 Additional Payments
  • IT0016 Contract Elements
  • IT0041 Date Specifications
  • IT0105 Communications
  • 0HR_PA_1 (Actions from IT0000/0302)
  • Optional: 0HR_PA_0 (Employee (Transaction Data))

The following basic key figures are created: FTE (Full Time Equivalent), Headcount, Age, Length of Service, and Amounts. In addition, characteristic values such as Full time/Part time, Nationality, Gender, Contract Type (Limited, Unlimited, Probationary Period) are made available.

In the standard solution, 20 classic HR reports on Headcount, Fluctuation, Age Distribution, etc. are delivered. Currently also included are Web Application Designer (WAD) templates for immediate integration into an SAP portal application.

One highlight of the package is the Change Analysis, which analyses the movements/changes of all available characteristics (e.g. Organization, Employee Subgroup, Cost Center, Pay Scale Group) and, in interaction with Measures, shows the effect of each change on the basic key figures (FTE, Headcount) as Receipt (employee joining), Issue (employee leaving) or Internal Change (e.g. change of capacity due to working time).

Changes can optionally be displayed by means of a waterfall chart.

In addition, basic pay information from infotypes 0008/0014/0015 is evaluated with current amounts (from pay scale tables for instance) in the course of the transfer, which means that having to actively establish a connection with the pay scale or wage type tables becomes obsolete.

Module “Organizational Management (OM)”

Organizational Management is an optional module, which focuses on the analysis of Staffing of Positions (Actual/Forecast). The analysis is generated on the basis of the extraction of standard elements from the SAP Organizational Management:

  • HRP-1000 Objects
  • HRP-1001 Relationships
  • HRP-1002 Description
  • HRP-1003 Department/Staff
  • HRP-1005 Planned Compensation
  • HRP-1007 Vacancy
  • HRP-1008 Account Assignment Features
  • HRP-1013 Employee Group/Subgroup
  • HRP-1014 Obsolete
  • HRP-1015 Cost Planning
  • HRP-1018 Cost Distribution

Key figures and reports on “Length of occupation”, “Amount of direct reports” and “Amount of (approved) positions” can be displayed for analysis purposes. In addition – but only if the operational HR processes will cover the issue – a comparison between Actual and Planned personnel is possible as well. Similarly, cost comparisons of Actual and Planned costs are possible in conjunction with our Payroll module (PY).

As is the case in the Personnel Administration module, the OM data are also determined accurately per month, which means that staffing (Actual/Planned) can be included in an EOY evaluation.

Beispiel SAP Dashboards für eine kombinierte Analyse PA/OM/Forecast

Module “Personnel Time Management (PT)”

Personnel Time Management is also an optional extension module, which focuses on attendances and absences and their analysis. Module “Personnel Time Management” allows the following components to be analysed:

  • PLANNED times (PT1)
  • ACTUAL times (PT2)
  • Absences (IT-2001)

The module provides the time data accurately per day, distinguishing between planned working times (Planned), attendances (Actual) and Absences (IT2001), determining the key figures

  • in hours and days
  • with and without public holidays in each case
  • in calendar days
Bsp. Design Studio für krankheitsbedingte Abwesenheitsanalyse

Specific characteristics and key figures are made available for the analysis of health-related absences:

  • Paid/unpaid absence (taking into account continued pay)
  • Hierarchy of health-related types of absence (with/without certificate, accident, health cure, reintegration)
  • Overall length of absence (calendar days)
  • Number of absences per period (relating to AU (unpaid absence) document entry)
  • First day of absence (weekday Mon, Tue, …, Fri)
  • Age/Length of Service

There is an enhancement available for including the quotas (PT3).

Module “Payroll (PY)”

The Payroll module involves the extraction of the revision information (PY_PP_1), complementing the data by replacing the symbolic account of the wage type by the Actual posting account (G/L account) of the SAP FICO application.

This allows you to evaluate the personnel costs from the Controlling perspective (cost center | G/L account) and from the perspective of HR management (organization | wage type) – taking into account the cost-producing period (For-Period) and the cost-effective period (In-Period).

Flexible extension options

The BW Business Content for HR from CubeServ represents best practice at a fixed price – and a solid foundation for further analyses and evaluations. You can integrate further modules, infotypes, tables or external sources into the content and adapt the data model logic (layer principle). You can connect individual data sources depending on the “originating” process and construct customer-specific or user-specific providers for the reporting, which link and connect the data from different processes.

The integration of non-HR data (e.g. from Settlement or Accounting) or of external benchmarking figures is also possible for mapping performance management key figures. This could include “Return on HCM-capital” incl. turnover/cost/personnel expenses, a comparison of the company’s own data with those of competitors/the sector as a whole and similar examples.

Frontend application – technically independent

Which SAP frontend application do you use / do you have licences for?

The more recent applications such as Design Studio, Lumira and Analysis Edition for Office (Excel, PowerPoint) or the older BO or BW applications (BEx, Web Application Designer), SAP Dashboards/Xcelsius?

Our Content can supply data to all these applications.

Further applications that are not part of the SAP portfolio can also be used, as long as they can process the DSO/InfoCube/MultiProvider data structures; ideally, access should be made via the classic SAP Query.


Our Offer

Any questions or require further information, our Expert

Johannes Kumpf

HR Analytics Expert with a passion for people analytics & HR planning. Business Development & Sales HRM @ CubeServ Group