Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Former Member
After watching lectures DMM268 and DMM300 at SAP Teched 2016, I was really excited about the possibilities of SAP BW and SAP HANA mixed architectures options.

Before we begin with the examples, let's have a quick overview of this concept.

What is a Data Warehouse Mixed Architecture?

It's an SAP best practice for modern data warehousing. Simply put, it's a data model that is implemented at the same time in SAP BW and native SAP HANA.

What are the benefits of this Mixed Architecture?

It combines processes, data and metadata of BW and native HANA, bringing the best capabilities of both worlds in order to gain flexibility and insight.

SAP HANA and SAP BW deliver integrated tools to manage mixed scenarios end-to-end, including modeling, transport mechanisms and consumptions interfaces.

SAP HANA database is the central runtime for reporting and data warehouse process, offering best in class performance and scalability.

Mixed Scenarios examples:

1 - Mixed Reporting Case

Mixed SAP BW and SAP HANA reporting:

  • OLAP processing done in BW analytic Engine;

  • Bex queries can be exposed as HANA views;

  • Consume directly on HANA using BI tools (e.g. Lumira);

  • HANA analytic privileges based on BW analysis authorization.

2 - Reporting on SAP HANA Views

Reporting on generated SAP HANA views for BW infoproviders

  • Data extracted, loaded and transformed in BW and stored in BW infoproviders;

  • Infoproviders can be automatically exposed as HANA views;

  • These generated SAP HANA views can be enriched in HANA Studio.

3 - Native HANA features for agile scenario

Using HANA-native features for agile scenarios:

  • Data can be loaded to a separate DB schema in HANA via SLT, ETL tool or file upload in HANA Studio;

  • HANA Modeler is used to build reporting views

  • SAP HANA views integrated into SAP BW using a Composite Provider.

4 - SAP BW for managing specific data

SAP BW for specific data consolidation:

  • Specific data managed by BW, e.g. master data, heterogeneous data from many sources, data from SAP ERP extractors);

  • These BW managed data objects are exposed to SAP HANA for further modelling;

  • BI clients can consume data via native HANA.

5 - Use of SAP BW Analytical Engine

  • Data not managed by SAP BW, completely modelled in SAP HANA;

  • SAP BW OLAP functionality “added” on top of SAP HANA models by integration it with a BW Composite Provider;

  • E.g. SAP HANA Live views integrated into BW.

These are just few examples of what can be achieved used SAP HANA and SAP BW mixed architecture.

Is your company using any of the above approaches?

Or have you ventured in another mixed architecture solution?

Feel free to share with us.