SAP Data Warehouse Cloud

Analytics applications – fast and agile
Thorsten Stossmeister
Competency Lead EDW/HANA

Confident and intelligent decision-making

With SAP Data Warehouse Cloud (DWC), SAP is now offering a cloud solution that allows analytics applications to be created in a fast and agile manner.

You will be able to gain new insights at a glance. Build your own data model to suit your needs, thus keeping in control of all changes and costs. SAP has made a promising start with this solution; further functions now need to follow speedily.

What impresses us most are the user’s freedom of action and the flexibility. Effective integration with professional display options (via the SAP Analytics Cloud) and straight-forward access to existing data sources round the offer of.

The use of separate “Spaces” guarantees your independence. With “Spaces”, you can set up your prototype in minutes, keeping your own data model secure.. Using your data model, you will be able to illustrate your requirements clearly and in detail, providing a good starting point for expanding the central data model in BW/4HANA. For finalisation or integration in existing data models, it is easy to hand over the “Space” to the IT specialists.

Data Warehouse Cloud offers all the benefits that you expect from a cloud solution: you pay precisely for what you order, based on your needs, and commit yourself only for a limited period. The test version (30 days) allows you to familiarize yourself with the solution so you hit the ground running.

The order for Data Warehouse Cloud can be placed directly online; deployment is largely automated and can therefore also be managed by the business department itself. Assistance from the IT department is usually only required for connecting to the source systems.

Modelling and visualisation are intuitive and can be performed by technically-minded business department users. No knowledge of SQL or programming skills are required.

Functionality

… at a glance!

Dashboards

• Based on SAP Analytics Cloud • Very extensive compatibility with SAC Stories • Integration with Application Builder planned • SAC Tenant incorporated in DWC

Extraction and modelling

• Replication of data from source systems • Data transformation via visual or SQL-based tools • Semantic layer to make data more easily comprehensible to business users

Source system connection

• Simple configuration • Connection to SAP systems via Data Provisioning Agent • No need for changes to the firewall, connection established via internal network • Additional security thanks to IP whitelisting

Spaces

• Separate Spaces possible for depart-ments/individual users • Isolation of all developments in separate Spaces • Simplification of Change Management through isolation • Object sharing between Spaces planned • Simple assignment of additional resources to Spaces

… and in great detail!

Dashboards

The SAP Data Warehouse Cloud solution offers the visualisation functionalities familiar from the SAP Analytics Cloud. Among other things, it allows ad-hoc analyses to be visualised and linked to create so-called Stories, which makes it possible to show the user a pre-defined path through the analyses. There are plans to integrate the Application Builder for realising comprehensive analytical applications at some point in the future. During the transition phase, everybody can, of course, make use of the SAP Analytics Cloud. In the course of the continuous development of SAP Data Warehouse Cloud, one can expect to see virtually all the SAP Analytical Cloud features being made available in the SAP Data Warehouse Cloud solution.

Extraction and modelling

Unlike SAP Analytics Cloud, which focuses on reporting, SAP Data Warehouse Cloud includes tools for creating more complex data transformations and models.

To this end, the data from the source systems are first replicated and transformed via views created through visualisation or via SQL before being integrated into ER models and published in the Business Catalog for further use.

Source system connection

The connection to on-premise systems is realised using a Data Provisioning Agent that needs to be installed within the internal corporate network; this makes it much easier to set up the connection as it does not usually require any changes to be made to the firewall. Once the connection has been established, all tables of the source system are immediately available for further use. The whitelisting of IP addresses enhances security further as it ensures that only authorised agents can access the relevant Data Warehouse Cloud tenant.

Spaces

In SAP Data Warehouse Cloud, the data models are stored in individual Spaces. Every Space is assigned resources of its own, which can be scaled up or down as required at any time.

Spaces also allow individual applications to be isolated, restricting them, for instance, to individual departments, reports, user groups or developers. This isolation simplifies development, administration, maintenance and cost allocation. It would, for instance, make it possible to delegate user administration for individual areas to business departments or to easily perform separate cost allocation based on resource assignment. In addition, it simplifies the development and maintenance of applications. Errors can be identified more quickly and enhancements to applications pose far less risk as there are fewer dependencies involved.

Webinars (in German language)

Webinar
Business Analytics Platform, CDS-Views, Data Warehouse Cloud, SAP Analytics Cloud, SAP Data Warehouse Cloud

Blog (in German language)

The SAP Data Warehouse Cloud – A New Big (?) Throw (Part 1)

What is the SAP Data Warehouse Cloud? If you want to take a look at the future of SAP products, the SAP Teched agenda (https://events.sap.com/teched/en/home) is a very useful crystal ball, at least for the near future. This agenda shows that SAP is focusing emphatically

The SAP Data Warehouse Cloud – A New Big (?) Throw (Part 2)

Administration as the beginning of all analysis In a new empty system there are always some administrative steps to be done first, fortunately in the SAP Data Warehouse Cloud there are only a few that absolutely have to be done. Of course, it starts with

If I only knew….

Glad you keep reading. Aristotle understood curiosity as a virtue. In private life, people often know the most intimate details about their best friends. But what about in business life? Let’s take a look at a company: Do you know their Strategy? Market positioning? Owner?

SAP Data Warehouse Cloud - Our Offer

Start right now and let’s create your first application together. Our workshop will cover the conceptual as well as the implementation phase. Furthermore, we will make sure that the DWC is properly connected to your source systems.

For further information, please contact our expert.

Adrian Bourcevet

Workshop

Coaching & Support