Oracle HRMS Intelligence (HRMSi) is a product in Oracle's E-Business Intelligence System application suite (E-BI) specific to human resources. HRMSi provides a web-enabled suite of strategic reports that provide summaries and details of HRMS application data. It also provides the tools to create your own reports.
The aim of HRMSi strategic reports is to enable you to measure, monitor and manage enterprise performance to make better, timelier decisions. To achieve this HRMSi uses a variety of reporting systems and database technologies to provide reports across the range of HRMS functionality.
Each module is described in detail below. You can choose to implement all, or individual modules, depending on which modules best meet your enterprise reporting requirements.
HRMSi uses Oracle Discoverer to create workbooks containing worksheet reports and graphs. The workbooks access your application data through a Discoverer End User Layer that organizes your application data into business areas and folders.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
The worksheets provide:
Summaries of your enterprise data.
Analyses of trends over time.
Comparisons of workforce changes across your enterprise.
The workbooks are ready to use. However, you can amend any of the supplied workbooks to meet your individual enterprise requirements. You can also use Discoverer User to create your own workbooks, based on the HRMS Discoverer End User Layer (EUL).
For a list of the HRMS Discoverer EUL Business Areas, see Discoverer End User Layer Business Area Descriptions, Oracle HRMS Configuring, Reporting, and System Administration Guide
You can find full instructions on developing the Discoverer EUL and creating and maintaining Discoverer workbooks in the Oracle Discoverer Plus User's Guide and the Oracle Discoverer Plus Administrator's Guide
Discoverer Analytics reports are Discoverer workbooks based on a set of facts and dimensions, similar to a data warehouse. They are intended for use by business analysts, or those wanting further understanding of HR data. They provide detailed analysis of aspects of the HR system, and are adept at analyzing data over time and comparing trends.
Some of the analytical structures are collected, and some are direct views of the HRMS transactional tables. This allows for near real-time reporting, with the advantage of collecting the more complex data that would otherwise impede the performance of the reports.
HRMSi also provides a set of analytical workbook templates based on the analytics summary structures so that you can extend the range of analytical reports as you wish. To develop reports using these templates, you need a good understanding of data warehouse structures.
HRMSi provides a set of business areas in the Discoverer End User Layer to support analytical reporting. For a list of the HRMSi Analytics Discoverer Business Areas, see Discoverer Analytics Business Areas
The following sections answer common questions on HRMSi strategic reporting and give an overview of the functionality.
HRMSi strategic reports are fully integrated with Oracle HRMS and allow you to gather high-level strategic information concerning the key business performance issues and business questions relating to human resources.
You can set targets for your business objectives, monitor performance, and receive notifications when performance is outside predefined tolerance limits for the targets; you can then respond quickly and effectively to maintain business performance.
You have pre-defined reports which can provide answers to typical, but complex, business questions, such as:
Are my different types of workers balanced to meet my business objectives?
Do salaries correlate with other factors, such as age or service?
How successful is my recruitment and what is the trend?
What competencies do my employees hold, and what competencies do they require?
Oracle HRMS Intelligence also provides an easy to use interface that enables you to produce adhoc reports across your system. It is a flexible system that enables you to extend the existing content. For analysis purposes, you can group employees by job, organization, cost-center, profit-center, ethnic or gender groups, age, service and compensation bands, to name only a few. In addition, the analytical concepts are easy to use, enabling you to do complex and detailed analysis of your workforce.
HRMSi reports do not, on the whole, report directly on data held in the HRMS transactional tables. Instead, they use a mixture of collected, pre-calculated information held in summary tables for complex data, and real-time data held in the transactional tables when reports require simple data.
The advantage of the summary tables is that you collect the more complex data prior to running the reports. The use of such complex data would otherwise impede reporting performance.
HRMSi provides programs you can run to update the data in the summary tables as often as you require.
In addition, HRMSi includes a performance management framework containing key performance indicators. You can set performance targets and receive alerts if your workforce changes become critical.
Strategic reporting therefore provides highly efficient summary information to enable you to quickly evaluate trends and statuses throughout your enterprise. This information enables you to respond in a timely manner to changes in your enterprise.
HRMSi recognizes that reporting requirements for an enterprise are unique. You can adapt the predefined Discoverer workbooks to match your exact criteria. You can create your own workbooks based on the predefined Discoverer end user layer. HRMSi also provides analytical workbook templates and an analytical end user layer to enable you to define your own analysis of your workforce.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
When accessing Human Resources secure folders in Discoverer, users will only be able to see data if they have a valid HRMS responsibility, that is, a responsibility that is registered to the HRMS suite. Therefore, before users access HRMSi reports, you must ensure that Human Resources security has been set up and that valid HRMS responsibilities have been assigned to those users.
Important: Unless you assign a valid HRMS responsibility to users, they will not be able to see any organization data.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
HRMSi provides four standard responsibilities. These are:
Human Resources Intelligence – Administrator (OLTP)
The existing Human Resources responsibility does not, by default, include all HRMSi reports and workbooks, since some workbooks are for administrative purposes. However, the Human Resources Intelligence – Administrator (OLTP) responsibility provides a full list of all reports, workbooks, and KPIs, apart from those in the data warehouse module. This responsibility is for use by system administrators; it should not be accessible to users.
Human Resources Intelligence – End User
The Human Resources Intelligence – End User responsibility provides an example template of how the administrator may want to present reports to users.
Human Resources Intelligence – Analytics User
The Human Resources Intelligence – Analytics User responsibility provides access to all the analytics reports.
Workforce is one of the key concepts used within the HRMSi reports. For information on how workforce is calculated, see: Workforce Calculation, Oracle HRMS Configuring, Reporting, and System Administration Guide
The HRMSi Discoverer Analytics workbooks and end user layer provide you with high level summary reports that track trends and statuses across a wide range of data. These workbooks enable you to compare your workforce activity across, for example, periods of time, organizational structures, or across types of employees or jobs.
To provide these high level summaries and comparisons, the analytics workbooks and end user layer rely on summarized data structures that are similar to the structures used in data warehousing. The summary data structures hold pre-calculated data. HRMSi provides a set of programs that you use to populate the summary structures with calculated data from your HRMS transactional tables. You can run the programs as often as you wish to keep the summary data up to date. See: Programs to Populate HRMSi Strategic Reports
HRMSi also provides analytics templates. You can use these templates to extend your range of analytics reports. To use the templates, you require a basic understanding of the following:
Oracle Discoverer
The principles of Online Analytical Processing (OLAP)
The principles of data warehousing
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
The HRMSi Analytics reports are based on a Discoverer end user layer (EUL). The analytics EUL provides folders that access the data from summary tables as well as the HRMS transactional tables. You can use these folders to create your own analytics reports. The analytics end user layer organizes the folders into three business areas, as described below.
HRMSi – Administration – Analytic Dimensions
This business area holds the dimension folders for analytics reporting.
HRMSi – Administration – Analytic Facts
This business area holds the facts folders for analytics reporting.
HRMSi – Administration – Analytic Components
This business area holds the component folders, such as lists and levels, for analytics reporting.
Some of the folders in the analytics business areas hold collected data. This is indicated in the folder name.
The analytics folders are for use by experienced developers who have an understanding of data warehouse structures.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.