SAP NetWeaver Business Intelligence

from Wikipedia, the free encyclopedia
SAP Business Warehouse
Basic data

developer SAP SE
Publishing year 1997
Current  version 7.5 SPS13
( September 19, 2018 )
operating system Linux , Microsoft Windows , AIX , HP-UX , Solaris
programming language ABAP , C
category Data warehouse
License proprietary license, end-user license agreement
German speaking Yes
Product page on sap.com

SAP Business Warehouse ( BW for short ) is the data warehouse application (DW for short) from SAP SE and part of SAP NetWeaver . BW consists of components for data management ( Data Warehousing Workbench ), for defining user queries via an OLAP processor ( Business Explorer , BEx for short ), a data mining environment ( analysis process designer , APD for short ) and a component for controlling the Loading processes. The current version of the business intelligence solution from SAP has the release number 7.5 and is part of SAP NetWeaver 7.5 .

application

BW is particularly often used for DW applications ( reporting ) in the SAP ERP environment, as BW contains pre-made ERP extractors and associated data elements, OLAP cubes and reports in the so-called Business Content . This should enable faster development of data warehouse applications. BW is an integral and free part of several SAP solutions. The resulting very high market share, especially in Germany, prompts many companies to introduce SAP BW as a uniform business intelligence platform for the entire company. Further advantages of BW are the integration with Microsoft Excel and the JavaScript- enabled browser-based evaluation. Products from other business intelligence providers are sometimes used as front ends in addition to BW.

For the end user who creates or evaluates reports, there are several user programs supplied by SAP, which are summarized under the generic term Business Explorer (BEx). The BEx Analyzer essentially consists of VBA macros for Microsoft Excel. The following programs run independently of Excel: The BEx Web Application Designer for designing web templates with interactive elements, the BEx Report Designer for specifically formatted reports, and the BEx Information Broadcaster for precalculating and sending reports.

In the next few years, the BEx tools will be supplemented by components from Business Objects and later replaced. The direct connection of Xcelsius 2008 to BW is already possible now.

Versions

The first version of the product was released in 1997 under the name Business Warehouse Information System . Since then, the product name has changed several times.

Surname version Release date
BIW 1.0E 1997
BIW 1.2A October 1998
BIW 1.2B September 1999
BIW 2.0A February 2000
BIW 2.0B June 2000
BIW 2.1C November 2000
BW 3.0A October 2001
BW 3.0B May 2002
BW 3.1 November 2002
BW 3.1C May 2003
BW 3.3 October 2003
BW 3.5 April 2004
BI 7th July 2005
BW 7.3 July 2011
BW 7.4 December 2013
BW 7.5 October 2015

Connection of data sources

The following options exist to connect data sources:

  • BI Service API (S-API): Direct connection of SAP source systems with the SAP Service API
  • File interface: Automatic import of files in CSV or ASCII format
  • DB Connect: Access to other databases via SAP-specific Database Shared Libraries (DBSL)
  • Universal Data Connect: Access to relational or multi-dimensional data sources based on a J2EE connector architecture
  • Web Services: Connection of XML data streams via the SOAP protocol

See also

literature

Practice-oriented introduction

  • J. Marx Gómez, C. Rautenstrauch, P. Cissek, B. Grahlher: Introduction to SAP Business Information Warehouse. Springer, Berlin 2006, ISBN 3-540-31124-6 .
  • J. Fischer, C. Brandt, B. Meyer: Data Warehousing with SAP Business Warehouse. Innovation Publication, Paderborn 2006, ISBN 3-937968-94-6 .
  • Stephan Kaleske: Practical manual SAP Query Reporting (=  SAP Press ). Galileo-Press, Bonn 2010, ISBN 978-3-8362-1433-9 .
  • Paul Rengier, Susanne Fritsch, Ralf Isken: SAP NetWeaver Business Warehouse The practical book . mitp Verlag, 2012, ISBN 978-3-8266-9220-8 (with CD).

Overview

  • Peter Chamoni, Peter Gluchowski, Michael Hahne: Business Information Warehouse. Perspectives for operational information supply and decision support based on SAP systems. Springer, Berlin a. a. 2005, ISBN 3-540-67528-0 .
  • Kevin McDonald, Andreas Wilmsmeier, David Dixon, Bill Inmon: Mastering the SAP Business Information Warehouse. 2nd Edition. BI 7.0, Wiley, New York 2006, ISBN 0-471-21971-1 .
  • Loren Heilig, Peter John, Torsten Kessler, Thilo Knötzele: SAP NetWeaver BW and SAP BusinessObjects: Data Warehousing and Reporting - all tools at a glance. (= SAP Press ). 2013, ISBN 978-3-8362-2048-4 .

Reporting

  • Frederic Heinemann, Christian Rau: Web development in ABAP with the SAP Web Application Server. Galileo Press, Bonn 2004, ISBN 3-89842-523-1 .
  • Norbert Egger, Jean-Marie R. Fiechter, Jens Rohlf, Jörg Rose, Oliver Schrüffer: SAP BW - Reporting and Analysis. Company-wide reporting with SAP BW 3.5 (= SAP Press ). 2005, ISBN 3-89842-537-1 .
  • Peter Lehmann: Modeling and reporting with SAP BW . Steinbeis Edition, 2005, ISBN 3-938062-17-7 .
  • Stephan Kaleske: Query reporting with SAP ERP (=  SAP Press ). Galileo-Press, Bonn 2009, ISBN 978-3-8362-1433-9 .
  • Joerg Boeke: SAP BW 7.x Reporting - Visualize your data . CreateSpace USA 2009, ISBN 978-1-4486-0626-9 .
  • Joerg Boeke: SAP BI Analysis Office - a Practical Guide . CreateSpace USA June 2015, ISBN 978-1-5123-8363-8 .

Database

  • Christian Mehrwald: Data warehousing with SAP BW 3.5 - architecture, implementation, optimization. dpunkt-Verlag, Heidelberg 2005, ISBN 3-89864-331-X .
  • Christian Mehrwald: Data warehousing with SAP BW 7 BI in SAP NetWeaver 2004s - architecture, implementation, optimization. dpunkt-Verlag, Heidelberg 2007, ISBN 978-3-89864-460-0 .
  • Stephan Kaleske: Query reporting with SAP ERP (=  SAP Press ). Galileo-Press, Bonn 2009, ISBN 978-3-8362-1433-9 .

Data modeling

planning

  • Norbert Egger, Jean-Marie Fiechter, Claudia Rohlf, Jörg Rose, Stefan Weber: SAP BW - planning and simulation - planning environment, planning functions and manual planning in SAP BW 3.5. (= SAP Press ). 2005, ISBN 3-89842-538-X .
  • Roland Fischer: Corporate planning with SAP SEM / SAP BW - Operational and strategic planning with SAP SEM / BW-BPS. (= SAP Press ). 2005, ISBN 3-89842-687-4 .
  • Peter Lehmann: Corporate planning with SAP BW . Steinbeis Edition, 2005, ISBN 3-938062-16-9 .

Web links

Individual evidence

  1. ↑ Release Notes . (accessed December 19, 2018).
  2. ↑ SDN: Overview of SAP History and BW-BI Evolution