Home > Store

SAP BW: A Step-by-Step Guide: A Step-by-Step Guide

Register your product to gain access to bonus material or receive a coupon.

SAP BW: A Step-by-Step Guide: A Step-by-Step Guide


  • Sorry, this book is no longer in print.
Not for Sale



Practical coverage of SAP's data warehousing tool, Business Information Warehous (BW), the core part of SAP's next generation products.

° BW is still a relatively new product, and there is little information available on it

° Shows ways to improve BW's performance, one of the most troublesome problems in BW systems

° Loaded with examples and screen shots


  • Copyright 2003
  • Dimensions: 7-3/8" x 9-1/4"
  • Edition: 1st
  • Book
  • ISBN-10: 0-201-70366-1
  • ISBN-13: 978-0-201-70366-5

SAP BW has recently come to the fore as a valuable tool for developing data warehouses that accurately and effectively support critical business decision making. It facilitates easy-to-use and high-performance extraction, transfer, transformation, and loading of data from a variety of data sources, including such comprehensive business management systems as SAP R/3.

This practitioner's guide uses step-by-step instructions complete with a plethora of screen captures to illustrate key SAP BW functionalities. It demonstrates how SAP BW implements the fundamental star schema and solves the major challenges inherent in the creation of data warehouses: performance, reliability, and error-handling. Using a real-world business scenario as a running example, SAP® BW presents a comprehensive view of the technology, from underlying concepts and basic techniques through its most sophisticated capabilities.

Specific topics covered include:

  • Creating an InfoCube and loading the data
  • Checking the accuracy of data with BW Monitor and the Persistent Staging Area (PSA)
  • Creating queries to generate reports using Business Explorer (BEx)
  • Managing user authorization with the Profile Generator
  • Advanced InfoCube design techniques
  • Aggregates and multicubes
  • Working with the Operational Data Store (ODS)
  • Installing business content and creating an R/3 source system in BW
  • Loading data from SAP R/3 into SAP BW
  • Data maintenance
  • Performance tuning, including parallel query option and data packet sizing
  • Object transport
  • Although the focus is on the core SAP BW technology, this book also discusses other relevant technologies, including Basis, ABAP (Advanced Business Application Programming), ALE (Application Link Enabling), and ASAP (Accelerated SAP) for BW.

    With the clear explanations and practical techniques presented in SAP® BW information systems professionals will gain both the general understanding and specific skills necessary to create high quality data warehouses that support effective decision making.


    Sample Content

    Online Sample Chapter

    Data Warehousing and SAP BW

    Downloadable Sample Chapter

    Click below for Sample Chapter(s) related to this title:
    Sample Chapter

    Table of Contents

    (NOTE: Each chapter concludes with a Summary.)




    1. Business Scenario and SAP BW.

    Sales Analysis—A Business Scenario.

    Basic Concept of Data Warehousing.

    Star Schema.

    ETTL—Extracting, Transferring, Transforming, and Loading Data.

    BW—An SAP Data Warehousing Solution.

    BW Architecture.

    BW Business Content.

    BW in mySAP.com.

    2. Creating an InfoCube.

    Creating an InfoArea.

    Creating InfoObject Catalogs.

    Creating InfoObjects—Characteristics.

    Creating InfoObjects—Key Figures.

    Creating an InfoCube.

    3. Loading Data into the InfoCube.

    Creating a Source System.

    Creating an Application Component.

    Creating an InfoSource for Characteristic Data.

    Creating InfoPackages to Load Characteristic Data.

    Checking Loaded Characteristic Data.

    Entering the Master Data, Text, and Hierarchy Manually.

    Master Data and Text.


    Creating an InfoSource for Transaction Data.

    Creating Update Rules for the InfoCube.

    Creating an InfoPackage to Load Transaction Data.

    4. Checking Data Quality.

    Checking InfoCube Contents.

    Using BW Monitor.

    Using the Persistent Staging Area (PSA).

    5. Creating Queries and Workbooks.

    Creating a Query Using BEx Analyzer.

    Organizing Workbooks Using BEx Browser.

    Using a Variable to Access a Hierarchy Node Directly.

    6. Managing User Authorization.

    Creating an Authorization Profile Using Profile Generator.

    Creating an Authorization Object to Control User Access to the InfoCube Data.

    Integrating Profile Generator and BEx Browser.


    7. InfoCube Design.

    BW Star Schema.

    InfoCube Design Alternative I—Time-Dependent Navigational Attributes.

    InfoCube Design Alternative II—Dimension Characteristics.

    InfoCube Design Alternative III—Time-Dependent Entire Hierarchies.

    Other InfoCube Design Techniques.

    Compound Attributes.

    Line Item Dimensions.

    8. Aggregates and Multi-Cubes.



    9. Operational Data Store (ODS).

    Creating an ODS Object.

    Preparing to Load Data into the ODS Object, Then into an InfoCube.

    Loading Data into the ODS Object.

    Loading Data into the InfoCube.

    Using 0RECORDMODE for Delta Load.

    10. Business Content.

    Creating an R/3 Source System.

    Creating a Logical System for the R/3 Client.

    Creating a Logical System for the BW Client.

    Naming Background Users.

    Creating an R/3 Source System in BW.

    Transferring R/3 Global Settings.

    Replicating R/3 DataSources.

    Installing Business Content Objects and Loading R/3 Data.

    11. Generic R/3 Data Extraction.

    Creating Views in R/3.

    Creating DataSources in R/3 and Replicating Them to BW.

    Creating a Characteristic in BW.

    Loading Data from R/3 into BW.

    12. Data Maintenance.

    Maintaining Characteristic Data.

    Maintaining InfoCube Data.

    InfoCube Contents.

    Indices and Statistics.

    Data Load Requests.

    Aggregate Rollup.

    InfoCube Compression.

    InfoCube Reconstruction.

    13. Performance Tuning.

    BW Statistics.

    System Administration Assistant.

    Tuning Query Performance.

    Query Read Mode.

    Bitmap Index.

    Statistics for the Cost-Based Optimizer.


    Parallel Query Option (PQO).

    Tuning Load Performance.

    Number Range Buffering.

    Data Packet Sizing.

    14. Object Transport.

    System Landscape.

    Development Class.

    Object Transport.

    Appendix A: BW Implementation Methodology.

    ASAP for BW.

    A Simplified BW Project Plan.

    For Further Information.

    Appendix B: SAP Basis Overview.

    SAP Basis 3-Tier Architecture.

    Presentation Interface.

    Application Server.

    Database Interface.

    Open SQL.

    Native SQL.

    Dispatcher, Work Processes, and Services.

    Dialog Work Process.

    Update Work Process.

    Enqueue Work Process.

    Background Work Process.

    Spool Work Process.

    Message Service.

    Gateway Service.

    Memory Management.

    SAP Buffer.

    Appendix C: Glossary.
    Appendix D: Bibliography.
    Index 447 0201703661T07092002


    Book Objective

    This book is a how-to guide. It uses step-by-step procedures with screen captures to illustrate SAP BW functionalities. This book focuses on the core SAP BW technology. It discusses other SAP technologies, such as Basis, ABAP (Advanced Business Application Programming), and ALE (Application Link Enabling) when necessary. It will not discuss 3rd-party reporting tools and BAPI (Business Application Programming Interface).

    Intended Readers

    This book is written for BW implementation teams and those who need a product to understand data warehousing concept.


    BW is built on Basis 3-tier architecture and coded in ABAP language. ALE and BAPI are used to link BW with SAP systems (R/3 or BW) and non-SAP systems.

    This book, however, does not require readers have knowledge in these areas. BW has made the development of a data warehouse so easy that people with experience in database design and computer programming can use it.

    Book Structure

    As shown in the table of contents, this book is organized into two parts:

    Part I contains guided tours. We start from a simplified business scenario, then go on to illustrates how to create an InfoCube, load data into the InfoCube, check accuracy of the loaded data, create queries to generate reports, and finally how to manage user authorization.

    Part II contains advanced topics. There we discuss InfoCube design techniques, aggregates, multi-cubes, operational data store (ODS), Business Content, generic R/3 data extraction, data maintenance, performance tuning, and object transport.

    In the appendices, we introduce ASAP (AcceleratedSAP) for BW, one of the derivatives of the ASAP implementation methodology developed by SAP, and give an overview of Basis 3-tier architecture.



    Click below to download the Index file related to this title:


    Submit Errata

    More Information

    Unlimited one-month access with your purchase
    Free Safari Membership