CubeServ HR Analytics
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.
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.
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:
In addition, the CubeServ Content covers special technical features of HR data, such as
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.
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.
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:
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.
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:
The module provides the time data accurately per day, distinguishing between planned working times (Planned), attendances (Actual) and Absences (IT2001), determining the key figures
Specific characteristics and key figures are made available for the analysis of health-related absences:
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.