As a new member of its Business Intelligence (BI) platform family, SAP has launched a cloud-based solution for Data Warehousing. Together with the already established SAP Analytics Cloud (SAC), the SAP Data Warehouse Cloud (inofficially also called SAP DWC so far) now constitutes the core of the “SAP HANA Cloud Services” portfolio. The new product in an SaaS (Software as a Service) model is a HANA-based end-to-end solution for Data Warehousing which combines data management processes with Advanced Analytics.
Within the SAP Beta Program, s-peers AG was among the first companies which exclusively performed intensive testing of the SAP Data Warehouse Cloud. In the process, we used various Proofs of Concept (POCs) to examine the new SAP cloud solution thoroughly in every detail – including error reports and suggestions for improvement which were returned to SAP as a direct feedback.
In order to do this, a data model and a story dashboard in the Finance area were set up exemplarily. Thereby all required steps (integration, harmonization and preparation of the data as well as the final visualization of the report) were considered precisely.
The SAP Data Warehouse Cloud (already generally available) offers the following components for this purpose:
In a POC, we have joined virtual database tables from an on-prem HANA (Journal Entry facts from SAP Business One as well as Cost Center and Account master data) in the DWC Data Builder and have combined them in a graphical view. In addition, various columns were created for the key-figure calculations – accompanied by the elimination of redundant columns.
In graphical modelling, the data flow is then generated quite simply with a few mouse clicks and is configured in the context menu of the individual functions (recognizable by the blue nodes). Subsequently, the created view can be used as a data model in the integrated Story Builder. Based on the data model, the following dashboard has been designed:
Data Warehousing of the Future
The above-mentioned examples demonstrate: The SAP Data Warehouse Cloud features a modern and visually appealing user interface which shares strong similarities with the SAC design. In the area of Data Warehousing, the SAP Data Warehouse Cloud offers an appropriate solution for the 21st century and thereby closes the previous gap in the backend segment of the BI Cl
We like to refer to our customer idorsia, who uses the DWC productively and proves that we talk about much more than theory.
You would like to get more information about this topic? Then we would be pleased to personally present you all functions and advantages of the SAP Data Warehouse Cloud – optionally also combined with details on the SAP Analytics Cloud if required. Just contact us!
Authors: Eugen Gering, Paul Vatter