Senior Vice-President of HCM Solutions Danielle Larocca has worked in the SAP HCM space for over 20 years. An SAP Mentor and featured speaker at numerous conferences, Danielle has authored four best-selling books on SAP, is the Technical Editor for the SAP Professional Journal, and often the Voice of the Expert on SAPInsider’s Ask the Expert series for HR.
SAP® and SuccessFactors customers have many options for reporting and analytics. In addition, SAP has the SAP Data Warehouse Cloud. This is a data and analytics solution providing the data warehouse as a service layer for SAP Business Technology Platform.
Many customers use the SAP Data Warehouse Cloud as a staging, clean-up or modeling system before they eventually publish their data into an analytics solution like SAP Analytics Cloud, Tableau or Microsoft PowerBI. Regardless of your strategy for reporting and analytics, Query Manager™ can serve as the engine to provide data to these disparate systems, including SAP Data Warehouse Cloud.
SAP Data Warehouse Cloud is used as a unified data and analytics solution that provides you with the ability to connect, transform, model, and visualize your data and gain real-time insights, whether it’s for analytics or for the preparation or staging of that data before it is moved to another system like SAP Analytics Cloud or the Digital Boardroom.
SAP Data Warehouse Cloud, available via the SAP Store, is an analytic and persona-driven data warehouse ‘as-a-service’ tailored for business and IT users. It provides instant access to data via pre-built business content and adapters to integrate data from various sources.
For those customers who would like to share their SAP ECC On-Premise or SAP SuccessFactors hybrid data dynamically with SAP Data Warehouse Cloud, we have a solution. You’re probably already familiar with the SAP certified solution, Query Manager. As the most popular reporting solution for SAP HCM and Payroll customers, Query Manager provides accurate, meaningful and real-time information from all of your SAP HCM and Payroll data whether you are on-premises in SAP ECC, in a hybrid SAP SuccessFactors environment or with SAP SuccessFactors Employee Central Payroll. And the exciting news is that Query Manager also serves as an engine for feeding all this data including configuration, custom tables, time and Payroll, with any external system with OData integration. This includes SAP Data Warehouse Cloud.
Query Manager extracts the relevant data for you (whether it be Payroll or PA, OM etc) without replicating the data, even for a sizeable volume.
You can build the queries, without writing code, without staging the data, in another system.
Query Manager generates a web service that exposes that data as an OData service that you can then consume via SAP Data Warehouse Cloud.
You can also combine on-premise data with other data sources including SuccessFactors that come from other parts of your ecosystem.
In the sample below, you can see the Query Manager data source listed in SAP Data Warehouse Cloud.
From the Data Builder, I can work with the various data sources, combining them, making relationships between them etc. to produce the data I am interested in, see below.
I can then expose this data as analytics in a dashboard, see below, or make it available to other systems for consumption including SAP Analytics Cloud. In the sample below, you can see a sample published story in SAP Data Warehouse Cloud populated with dynamic data from an SAP HCM and Payroll system.
What’s ideal is that you can easily refresh the data within SAP Data Warehouse Cloud, on demand, to retrieve the latest available data to you (no more uploading and downloading).