Strategic Reporting (HRMSi) User Guide

Strategic Reporting Overview

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.

Discoverer Workbooks and End User Layer (EUL)

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:

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

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, Oracle HRMS Deploy Strategic Reporting (HRMSi)

What is Strategic Reporting?

The following sections answer common questions on HRMSi strategic reporting and give an overview of the functionality.

What does Strategic Reporting mean?

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:

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.

How does strategic reporting differ from standard workforce intelligence?

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.

How can HRMSi meet my enterprise's unique reporting requirements?

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.

Strategic Reporting Key Concepts

Workforce

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