SAP NetWeaver Business Warehouse

From Wikipedia, the free encyclopedia
Jump to: navigation, search

SAP Business Warehouse SAP Business Warehouse (SAP BW) is the cornerstone of SAP’s strategic Enterprise Data Warehouse solutions and runs on industry standard RDBMS and SAP's HANA in-memory DBMS. It delivers reporting, analysis and interpretation of business data that is crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to respond quickly to meet market opportunity. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data.


SAP's BI products have layers:

  • Extract, transform, load (ETL) layer - responsible for extracting data from a specific source, applying transformation rules, and loading it into the Data Warehouse Area.
  • Data Warehouse Area - responsible for storing the information in various types of structures (e.g. Data Store Objects, InfoObjects and multidimensional structures called InfoCubes that follows star schema design).
  • Reporting - for accessing the information in data warehouse area and presenting it in a user-friendly manner to the analyst or business user.
  • Planning and analysis - Provides capabilities for the user to run simulations and perform tasks such as budget calculations.

SAP BW contains pre-defined business content in the form of InfoCubes, Info Objects, authorization roles, and queries. The business content can be modified to meet an organization's specific requirements; however, this requires a longer process of customization of the pre-defined elements.


User management[edit]

The following types of general user profiles exist:

  • Executives and knowledge workers
  • Information consumers

However, roles and authorizations can be customized significantly.

Authentications and Single Sign-On[edit]

The following are the most common forms of authentication:

SAP NetWeaver Single Sign-On Environment[edit]

The SAP NetWeaver Portal is the main entry point within SAP NetWeaver. In order to integrate SAP NetWeaver Business Intelligence, the following two conditions must be satisfied: (note that SAP logon tickets are being used in this example) 1) BI trusts SAP logon tickets from EP because the public key of the EP certificate has been imported into BI. 2) EP trusts SAP logon tickets from BI because the public key of the BI certificate has been imported into EP.


Companies have to define who has access to which data. An authorization allows a user to perform a certain activity on a certain object in the BI system. There are two authorizations concepts to consider for BI: standard authorizations[1] and analysis authorizations.[2]

Communication channel security[edit]

The communication channel used depends on different cases[3]

  • Front end and application server uses RFC
  • Application server and application server uses RFC
  • SAP J2EE Engine and application server uses RFC
  • SAP router and application server uses RFC
  • Connection to database uses RFC
  • Web browser and application server uses HTTP, HTTPS, and SOAP
Encrypted communications[edit]

RFC communications is not encrypted. In order to encrypt RFC communications, the SAP environment must use Secure Network Communications (SNC) or the SAP Cryptographic Library.[4] SAP recommends the usage of x.509 certificates.[5]

Data storage[edit]

Data can be protected from being accessed by an authorized end user by assigning analysis authorizations. Data is not protected under BI default settings.

Transactional data is stored in a Datastore or an InfoCube. A Datastore serves as a storage location for transaction data at an atomic level. The data in a datastore is stored in transparent flat database tables.

An InfoCube is a set of relational tables arranged according to the star schema: A large fact table in the middle surrounded by several dimension tables.


In 1998, SAP released the first version SAP BW providing a model-driven approach to EDW which made data warehousing easier and more efficient for SAP R3 data. Over the past 16 years SAP BW has evolved to become a key component for tens of thousands of companies EDW.

See also[edit]


Further reading[edit]

  • Shiralkar; Shreekant, Amol Palekar, Bharat (2010). A-Practical-Guide-to-SAP-NetWeaver-Business-Warehouse-7.0 (First Edition ed.). SAP Press. ISBN 978-1-59229-323-0. 
  • McDonald; Wilmsmeier, Dixon, Inmon (2006). Mastering the SAP Business Information Warehouse (Second Edition ed.). Wiley. ISBN 0-471-21971-1. 
  • Mehrwald, Christian (2003). SAP Business Information Warehouse 3. Heidelberg: dpunkt-Verlag. ISBN 3-89864-179-1. 
  • Scott, Peter (2006). SAP Business Explorer (BEx) Tools. SAP Press. ISBN 1-59229-086-8. 
  • Scott, Peter (2009). SAP Business Explorer (BEx) Tools 2nd Edition. SAP Press. ISBN 1-59229-279-8. 
  • Boeke, Joerg (2009). SAP BW 7.x Reporting - Visualize your data. Createspace USA 2009. ISBN 978-1-4486-0626-9.
  • Shiralkar; Shreekant, Amol Palekar (2012). Supply Chain Analytics With SAP NetWeaver Business Warehouse (First Edition ed.). Tata McGraw-Hill Education. ISBN 978-1-2590-0608-1. 

External links[edit]