SAP Business Warehouse

Service offerings


SAP Business Warehouse (SAP BW) - also known as SAP Netweaver Business Intelligence (SAP BI) - is the name of the Business Intelligence, analytical, reporting and Enterprise Data Warehousing (EDW) solution of SAP AG. It was originally named SAP BIW (Business Information Warehouse).

SAP BW consists amongst other things of components for the integration, transformation, consolidation, cleanup, and storage of data (Data Warehousing Workbench), extensive data modeling capabilities, an embedded analytical engine, a suite of rich front-end analytical tools referred to as Business Explorer (BEx), operational tools used for importing the most current transactional data into the system and managing the data warehouse processes, a Metadata Repository, Business Planning and Simulation (SAP BPS), and special analysis processes such as data mining.

SAP shares its deep knowledge of the most varied business and industrial applications with its users. This knowledge, which helps users to make their decisions, is available as BI Content (included free of charge with a SAP BW installation). The high degree to which SAP applications are integrated with SAP NetWeaver BI enables you to use preconfigured, role-based information models of BI Content for analysis, reporting and planning. BI Content provides the relevant BI objects for selected roles within a company, from extraction to analysis, in an understandable, consistent model. BI Content thus permits you to introduce SAP NetWeaver BI efficiently and cost-effectively in your company. It is delivered by SAP and can be used either directly or as a template to be adapted to customer needs.

More recently, SAP HANA has been added to the EDW (Enterprise Data Warehouse) -platform. SAP HANA is an in-memory data platform that is deployable as an on-premise appliance, or in the cloud. It is a relatively new data platform that's best suited for performing real-time analytics, and developing and deploying real-time applications.

Enterprise Data Warehouses (EDW) traditionally have three purposes:

  • Consolidating data from disparate systems into homogeneous objects designed with online analytical processing (OLAP) in mind, leveraging a common set of standards and master data
  • Ensuring that the OLAP workload would not interfere with SAP ERPs job of executing business transactions (to do this, BW and ERP typically ran on separated databases with their own application servers)
  • Ensuring that response times would be reasonable (to achieve this, traditional data warehouses store data in aggregated forms)

In those cases where a customer needs Enterprise Data Warehouse processes, SAPs standard solution is becoming SAP BW on HANA, extended by native SAP HANA Data Warehousing capabilities.

We are experienced and happy to assist our clients with the latest EDW technologies and related services:

  • SAP BW on HANA,
  • SAP HANA, SQLScript, HANA Live
  • Side-Car implementation on HANA
  • HANA implementations and consulting
  • HANA testing and data migration
  • Planning and Roadmaps toward SAP HANA based technologies

element61 has over 50 manyears of experience in SAP Business Warehouse - SAP Netweaver Business Intellligence with a particular focus on migrating from version 3.5 to 7.x, and the latest BW 7.5 on HANA, design & performance tuning, data governance processes around SAP BW, SAP HANA, mixed scenarios, and integration with the modern Presentation Layer tools such as BusinessObjects. C4A, Fiori apps.

Contact us for more information on SAP Business Warehouse and SAP HANA !