Hybrid Human Resources (HR) Analytics (the hybrid BI solution with on-premise and cloud sources)
White paper (Title)
Hybrid Human Resources (HR) Analytics (the hybrid BI solution with on-premise and cloud sources)
Authors
- Haran Vinayagalingam: Senior Director-SAP HANA Center of Excellence, Platform Solutions Group at SAP
- Sathees (Sat) Kana: Managing Principal – Data Science & Analytics at Smartsoft International Inc.
Affected Industries
All
Executive Summary
Digital transformation is leading companies to adapt more and more cloud solutions. The cloud solutions allow companies to scale as the business demand changes. However, most of these enterprises also have their on-premise applications for the time being required to run, at lease while they are moving on to cloud. During this transition period the challenge is to integrate both on-premise and cloud solutions for a comprehensive analytical need. We have identified four scenarios based on our experience with customers. For this discussion, we have decided to use SAP SuccessFactors and the on-premise solution. In a series of blogs, we will explain each scenario and how customers can overcome comprehensive analytical needs of Human Capital Management (HCM).
Scope
As mentioned on the above section, following are the four options on this regard:
- SAP HCM and SuccessFactors mixed scenario: ECC and SF as source to produce reporting on BO Product Suite or BusinessObjects Cloud or 3rd party BI tools
- SAP HCM only as HR solution: ECC as source and BW as next data warehousing tier then BO Product Suite or BusinessObjects Cloud or 3rd party BI tools
- SAP SuccessFactors only as HR Solution: SF as source and BI reporting via BO Product Suite or BusinessObjects Cloud or 3rd party BI tools
- SuccessFactors and Non SAP HR solutions: SuccessFactors and Non SAP as source to produce reporting on BO Product Suite or BusinessObjects Cloud
In a series of blogs we will cover all four scenarios and design principles to address reporting need. First and foremost this blog will cover the on-premise SAP HCM and Cloud Solution SuccessFactors
Design
For Human Resources, subject areas like Employee, Benefits, Compensation, Payroll, Personal Development, Learning, Recruiting, Travel, Compliances and Government Rules, there are no encompassing analytical solution that can provide an easy, faster and integrated approach to its audience. Specially, SAP’s acquisition of new systems and 3rd party systems on HR, there is no common solution on analytics. Target audience need to connect and work with multiple systems for reporting needs and need to do manual consolidation. Simply, there is no single point of entry to a complete reporting and dashboarding solution on HR. This is affecting all industries.
Approach
Hybrid HR Analytics, the Human Resources Business Intelligence (All In One) develops a custom solution that alleviates Human Resources related data extraction from different source systems to a single front end. This uses SAP’s latest toolset on cloud – BusinessObjects Cloud, which provides any level of human resource reporting needs with forecasting and predictive analytical capability.
For this common front end following sources can be connected, as explained in the table below:
Source system | Connection mechanism | Benefited Modules |
SuccessFactors Source | SAP Businesses Objects Cloud uses direct connection using OData. This connection explores models/models in SuccessFactors |
· Employee Central · Benefits · Compensation · Learning · Recruiting · Performance & Goal · Succession & Development · On boarding (New hire) · SAP Jam · Time Management |
SAP ERP/HCM Source
|
SAP BusinessesObjects Cloud uses BOBJ Cloud agent and SAP HANA Cloud Connector from the local network |
· Employee (PA) · Benefits · Compensation · Payroll · Personal development · Learning · Recruiting · Travel · & Finance (HR) |
SAP BW Sources | SAP BusinessesObjects Cloud uses BOBJ Cloud agent and SAP HANA Cloud Connector from the local network |
· Employee (PA) · Benefits · Compensation · Payroll · Personal development · Learning · Recruiting · Travel · & Finance (HR) |
3rd party Sources | SAP BusinessesObjects Cloud uses BOBJ Cloud agent and SAP HANA Cloud Connector from the local network with SQL Databases, etc. |
· Employee · Benefits · Compensation · Payroll · Personal development · Learning · Recruiting · Travel · & Finance (HR) |
Benefits
- Data acquisitions from SAP HR Finance, Human Capital Management application (HCM), SuccessFactors (Cloud) and 3rd party software using common utility.
- A common reporting solution provides Canned, Ad-Hoc, Self Service and C-Level Reporting.
- Dashboard that provides slicing & dicing and drilling to the detail level on data discovery and data exploration.
- All-in-one with single point of entry to the full HR reporting need
- Accelerated implementation with Proven Key Performance Indicators
- Advantages over other Rapid Deployment Solutions.
Conclusion
In summary, it is imperative to design a HR data warehouse which is in line with overall strategy of a company; unlike other data warehouse, traditionally the HR data is bound to local and federal government statutory requirement to protect any personal information. These protection levels varies state to state, country to country. Therefore, any organization which is deciding to build their HR data warehouse should determine whether to implement the solution on cloud or on premise. Once it is determined selecting integration and data staging strategy needs to be decided. It is crucial to select the tools that can be used for all of the integration points rather than multitudes of tools. SAP considers the SAP HANA Cloud Platform as the layer which enables integration between on premise and cloud applications and providing a single point for data convergence and reporting.
References and help links
SAP BusinessObjects Cloud Agent
Installing SAP BusinessObjects Cloud Agent
Updating SAP BusinessObjects Cloud Agent
Installing the SAP HANA Cloud Connector
Configuring the SAP HANA Cloud Connector
Configuring SAP BusinessObjects Cloud Agent
SAP BusinessObjects Cloud Agent
Import Data Connection to an SAP BW System
Import Data Connection to an SAP BPC System
Import Data Connection to a Universe (UNX)
Import Data Connection to an SAP ERP System
Import Data Connection to an SQL Database
Import Data Connection to SuccessFactors
Import Data Connection to OData Services
Import Data Connection to Salesforce (SFDC)
Allowing Data Import from File Server
Thank-you Haran
Thanks Sathees. Your work will provide good insight for HR fraternity