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.