Friday 2 December 2016

SAP HANA and BW Mixed Scenarios Architecture

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.

SAP HANA and BW Mixed Scenarios Architecture
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

SAP HANA and BW Mixed Scenarios Architecture

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

SAP HANA and BW Mixed Scenarios Architecture

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

SAP HANA and BW Mixed Scenarios Architecture

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 HANA and BW Mixed Scenarios Architecture

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

SAP HANA and BW Mixed Scenarios Architecture

  • 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.

No comments:

Post a Comment