ANALYTICS AND REPORTING TOOL FOR HUMAN CAPITAL MANAGEMENT (HCM)
Described herein is a reporting framework. In accordance with one aspect of the framework, data is modeled into business-oriented data, wherein the data utilizes flat-table data modules. A subset is selected from the business-oriented data, and a dataset may be retrieved based on the subset. The retrieved dataset may be converted into structured query language (SQL) expression, which is then used to report the dataset.
1 . A method of implementing an analytics and reporting tool, the method comprising:
modeling data into business-oriented data, wherein the data utilizes flat-table data modules;
selecting a subset from the business-oriented data;
retrieving a dataset based on the subset;
converting the retrieved dataset into structured query language expression; and
reporting the dataset using the structured query language expression.
2 . The method according to claim 1 , wherein modeling the data is implemented by using:
a Source-View, wherein the Source-View is a name for INFOTYPE or flat table in the flat-table data modules;
an Entity, wherein the Entity represents business-oriented objects; and
attributes of the Entity, wherein the attributes of the Entity map to a field in the Source-View.
3 . The method according to claim 2 , wherein a key performance indicator is calculated by holding a sequence of information that includes which association the Entities are connected to, wherein the association defines a relationship between the Entities.
4 . The method according to claim 2 , wherein a key performance indicator is calculated by holding a sequence of information that includes what attributes are selected from the Entity to calculate the key performance indicator.
5 . The method according to claim 1 , wherein the flat-table data modules include personnel time management and payroll data modules, the personnel time management and payroll data modules are consolidated and transactional data modules.
6 . The method according to claim 1 , wherein selecting the subset further comprises:
choosing a key performance indicator out of a key performance indicator repository, wherein the chosen key performance indicator includes a minimum subset; and
finding a dimension that is connected by associations and entities.
7 . The method according to claim 1 , wherein the structured query language expression is consumed by a third party reporting tool.
8 . The method according to claim 1 further comprising converting the retrieved subset into a structured query language query.
9 . The method according to claim 1 further comprising converting the business-oriented data into dynamic structured query language expression, wherein the converting utilizes an iterative way.
10 . The method according to claim 9 , wherein the iterative way includes converting first an individual attribute group, wherein based from the conversion of the individual attribute group, Entities are converted next, wherein corresponding key performance indicator is next converted into structured query language expression.
11 . One or more computer-readable media storing processor-executable instructions that when executed cause one or more processors to perform operations that facilitate reporting, comprising:
modeling flat-table data modules into business-oriented data;
selecting a subset from the modeled flat-table data modules;
retrieving a dataset based on the subset;
converting the retrieved dataset into structured query language expression; and
reporting the dataset using the structured query language expression.
12 . The one or more computer-readable media according to claim 11 , wherein modeling the flat-table data modules is implemented by using:
a Source-View, wherein the Source-View is a name for INFOTYPE or flat table in the flat-table data modules;
an Entity, wherein the Entity represents business-oriented objects; and
attributes of the Entity, wherein the attributes of the Entity map to a field in the Source-View.
13 . The one or more computer-readable media according to claim 12 , wherein a key performance indicator is calculated by holding a sequence of information that includes which association the Entities are connected to, wherein the association defines a relationship between the Entities.
14 . The one or more computer-readable media according to claim 12 , wherein a key performance indicator is calculated by holding a sequence of information that includes what attributes are selected from the Entity to calculate the key performance indicator.
15 . The one or more computer-readable media according to claim 11 , wherein the flat-table data modules include personnel time management and payroll data modules, the personnel time management and payroll data modules are consolidated and transactional data modules.
16 . The one or more computer-readable media according to claim 11 , wherein selecting the subset further comprises:
choosing a key performance indicator out of a key performance indicator repository, wherein the chosen key performance indicator is a minimum subset; and
finding a dimension that is connected by associations and Entities.
17 . The one or more computer-readable media according to claim 11 further comprising receiving of the selected subset.
18 . A system that facilities a reporting tool to users, the system comprising:
a modeling component that models data into business-oriented data, wherein the data utilizes flat-table data modules;
a design time component that receives the business-oriented data, wherein a subset is selected from the business-oriented data;
a query generation engine that receives the selected subset, wherein the query generation engine retrieves dataset based from the selected subset and converts the retrieved dataset into structured query language expression; and
a runtime component that receives the retrieved dataset and generates a report for the dataset using the structured query language expression.
19 . The system according to claim 18 , wherein the flat-table data modules include personnel time management and payroll data modules, the personnel time management and payroll data modules are consolidated and transactional data modules.
20 . The system according to claim 18 , wherein the query generation engine converts the received selected subset into a structured query language query.