Thursday, February 23, 2023

What is embedded BW (part 2)?

I dedicated a blog post to the topic of Embedded BW in past already. However, the topic is quite broad so I decided to write a follow up.

First to sum up a purpose of the SAP Embedded BW (Business Warehouse). It is a data warehousing solution that is integrated within the SAP Enterprise Resource Planning (ERP) system. It allows organizations to collect, consolidate, and analyze data from various sources within the SAP environment, as well as external sources.

As it is “Embedded” BW into NetWeaver based systems (such an ERP (SAP Business Suite, SAP S/4HANA), SAP CRM, etc.) it means it provides a real-time view of an organization's data, enabling decision-makers to make informed business decisions. It provides advanced reporting and analytics capabilities, including ad-hoc reporting, OLAP analysis, and predictive analytics. These capabilities enable users to gain insights into business performance and identify trends and patterns in the data.

One of the key benefits of Embedded BW is that it eliminates the need for separate data warehousing infrastructure and reduces the cost and complexity of managing multiple systems. It is also designed to be scalable, allowing organizations to expand their data warehousing capabilities as their data volumes grow.

However, the Embedded BW just supports processes related to financial planning, consolidation and data analytics but it is not intended to be used as data warehouse solution. For pure enterprise data warehousing (EDW) purpose the SAP BW should be used.

Current version of BW used in the embedded BW SAP BW 7.5 powered by SAP HANA. As per SAP, (see Embedded SAP BW Definition and Positioning document) there are currently no plans to enable SAP BW/4HANA for Embedded BW.


More information:

Embedded BW part 1

2935516 - Embedded BW is not intended to be used for data warehousing

2773652 - Recommendations embedded SAP Business Warehouse

1972819 - Setup SAP BPC optimized for S/4 HANA Finance and Embedded BW Reporting (aka Integrated Business Planning for Finance)

No comments: