SAP Data Warehouse – the basis for business analytics
SAP Data Warehouse
Central component of a powerful business analytics infrastructure

SAP Data Warehouse – effortlessly consolidate corporate data

The central component of a powerful business analytics infrastructure

To get a complete view of your business processes, you first need a powerful business analytics infrastructure as a basis.

In addition to a modern and user-oriented portal technology with access to numerous tools for reporting, planning and consolidation, the SAP Business Warehouse (SAP BW), as a central data repository for data from SAP and non-SAP sources is the core building block of most customers’ analytics infrastructure.

In the business warehouse, data is extracted from a wide variety of operational systems and databases, transformed, consolidated and made available in the cloud and on-prem in a uniform manner forreporting and analysis purposes.

The business intelligence solution SAP Analytics Cloud (SAC) allows you to visualize a BW’s data in the cloud. In the on-prem variant, the front ends of the BO server (BusinessObjects), such as Lumira, are available.

SAP offers three different technologies for data warehousing as part of the SAP Business Technology Platform: SAP BW/4HANA, SAP Datasphere (previously SAP Data Warehouse Cloud (DWC)) and SAP HANA SQL Data Warehouse.

Unrestricted system openness with SAP HANA SQL Data Warehouse

SAP HANA has supported SQL Data Warehousing for years. SAP HANA for SQL Data Warehousing is a solution that uses open SQL standards. It allows customers to combine any tool or technology to create a customized “best-of-breed” data warehousing solution.

SQL DW requires the universal programming language SQL, which is the solution’s real strength. This makes SQL DW very flexible and enables (almost) unlimited system openness.

SAP BW/4HANA – the successor to SAP BW

SAP BW/4HANA is the logical further development of SAP BW on HANA and BW 7.5. This data warehouse is the central development platform for reporting, planning and consolidation applications in the on-prem environment.

Since BW/4HANA was developed specifically for the HANA in-memory database, all of HANA’s functional and performance advantages can be optimally utilized.

By storing data in RAM, column-oriented organization and HANA-optimized data models are guaranteed extremely fast response times, even with huge amounts of data (Big Data). As well as analytical performance, you benefit from SAP HANA during the ETL process too. ETL (Extract, Transform, Load) is a process of unifying data from multiple, differently structured data sources into a target database. Various actions in the ETL process are outsourced to SAP HANA to improve performance. This eliminates the need for data exchange between SAP HANA and the ABAP stack.

The proven tools SAP Analytics Cloud, SAP Analysis for Office and SAP Lumira are available for evaluating and visualizing your BW/4HANA data. What’s more, SAP Digital Boardroom enables executives to perform ad-hoc reporting, conduct “what if” analyses and have real-time access to contextual information.

SAP BW/4HANA is available to you both as a cloud solution and in the on-prem variant. Provisioning takes place using the managed cloud service SAP HANA Enterprise CloudMicrosoft Azure or Amazon Web Services (AWS).

The graphic below illustrates the architecture of SAP BW∕4HANA:

Graphic of the SAP BW/4HANA architecture

SAP Datasphere – flexible and agile

The SAP Datasphere is a newly developed data warehouse solution in the cloud (SaaS) that maps the complete data warehousing process using the latest technologies.

SAP Datasphere also gives users from the business departments simplified access to company data. You can not only analyze them, but also extend existing IT data models and build your own models. This also eliminates the need to store your own copies of data in local systems. The advantages are obvious. The business departments benefit from the flexibility and agility gained during the analysis process, and the IT department doesn’t have to worry about how secure the company’s data is.

SAP HANA – the powerful in-memory database

SAP HANA is a powerful in-memory database that enables you to make fast and sound decisions. HANA enables real-time access to all the operational applications’ data and business information, as well as its immediate further processing and evaluation.

Rapid response times even for the largest data volumes thanks to SAP HANA

HANA is a flexible, versatile solution consisting of SAP software and customized hardware. This makes it possible to evaluate business transactions at different aggregation levels at any time. Whether business metrics are operational or consolidated, HANA lets you intuitively create the right analytics.

In interaction with the analytics tools from the SAP BusinessObjects portfolio, companies benefit particularly greatly from the in-memory database that the data warehouse solution features. Users gain comprehensive insights and analysis capabilities for all the supported systems.

The ORBIS consulting portfolio for your company

ORBIS offers customers holistic support when it comes to modernizing their reporting operations. From classic on-prem data warehouse projects to current cloud solutions, like SAP Analytics Cloud, ORBIS is your partner for success.

With our more than 15 years of consulting expertise in the SAP BW environment and the resulting project experience, we adapt your IT infrastructure to suit your individual requirements: from smaller Business Warehouse installations to data storage with several terabytes and lots of source connections. 

Customer success stories with ORBIS
Success Stories
Logo ZF Friedrichshafen AG
Manual actual data collection and PPM target value planning with SAP BW IP and SAP Design Studio in Quality
Logo Rittal GmbH & Co. KG
BW-integrated planning instead of Excel: Rittal is transparently planning customer and project sales with IT support
Logo Hager SE
State-of-the-art and optimized KPI reporting with SAP BW/4HANA and self-service BI from SAP Analytics Cloud
Logo Friedhelm Loh Group
SAP BPC at the Friedhelm Loh Group
Dashboard based on the SAP Analytics Cloud: BOMAG optimizes and simplifies KPI reporting
Logo Hager SE
State-of-the-art KPI-Reporting with self-service BI tools and more besides: The Hager Group is introducing SAP BW/4HANA and SAP Analytics Cloud
Logo LAPP Insulators, PFISTERER Holding AG
LAPP Insulators introduces SAP BPC


Logo of AG der Dillinger Hüttenwerke

use frontends and query design

Logo of Hager SE

use BW/4HANA


use SAP BW and Lumira Designer

Logo of Minol Messtechnik W. Lehmann GmbH & Co. KG

SAP BW on HANA Migration

Logo of Stabilus S.A.


SAP Business Analytics Portfolio
Embedded Analytics
More information on SAP Embedded Analytics
Embedded Analytics

With the new ERP system S/4HANA, SAP offers the next step towards a modern, integrated platform for the constantly growing requirements of a state-of-the-art IT system.

Business Analytics SAP

The increasing flood of information, the demand for ever shorter reaction times and the increasing responsibility in the operative business increase the demands on a modern reporting system.

Analytics Frontends
More information on Business Analytics frontends
Analytics Frontends

Transform company data from different sources into relevant information

Augmented Analytics
More information on SAP Augmented Analytics
Augmented Analytics

Forecasts the most promising business opportunities and minimizes your commercial risk

Planning and consolidation
Planning and consolidation with Business Analytics
Planning and consolidation

Powerful tools for modern reporting

SAP Analytics Cloud
More information on SAP Analytics Cloud (SAC)
SAP Analytics Cloud

The SAP Cloud solution for business analytics allows you to use a modern platform if you need to present your data in a modern and comprehensible way.

Tel.: +1 (703) 734-6494 (0)