SAP BW Data Retrieval: Mastering the ETL process

This much anticipated reference makes an excellent addition to your SAP BW Library. Read this book and you’ll discover a comprehensive guide to configuring, executing, and optimizing data retrieval in SAP BW.

The author takes you, step-by-step, through all of the essential data collection activities and helps you hit the ground running with master data, transaction data, and SAP Business Content. Expert insights and practical guidance help you to optimize these three factors and build a successful, efficient ETL (extraction, transformation, loading) process.

This all-new edition is based on the current SAP BW Release 3.5, but remains a highly valuable resource for those still using previous versions.

Highlights include:

• Detailed ETL Concepts and Implementation within SAP BW
• Extractors: Overview of Available Techniques: Homogenization of Data, Data Extraction from Heterogeneous Systems, Extraction Mechanisms in SAP BW
• ETL Process: Master Data: Data Targets, Update Types and Rules, DataSources, InfoPackages
• ETL Process: Transaction Data - SAP Business Content DataSources, InfoSources, Transfer and Update Rules
• SAP Business Content: Elements and Areas of Use
• Detailed Sample Scenario
• Comprehensive Appendix: Includes BW Glossary, Transaction Codes, Metadata Tables, Index
• ... and much more!

Norbert Egger is the Managing Director of the CubeServ Group, which specializes in BI solutions. In 1996, he established the world’s first data warehouse based on SAP. Since then, he has implemented hundreds of projects with SAP BW and SAP SEM. He has many years of experience in the operation of SAP-based BI solutions.

Jean-Marie R. Fiechter has worked as a senior data warehousing consultant at CubeServ AG (Jona, Switzerland) since 2003 and is a certified SAP NetWeaver Business Intelligence consultant. He has international, practical experience in the areas of data warehousing, business intelligence, massively parallel processing, and management information systems (MIS). For the past several years, he has taught data warehousing at various universities and colleges. In addition, he works as a BI instructor on behalf of SAP.

Robert Salzmann works as a consultant at CubeServ AG (Jona, Switzerland), which specializes in business intelligence solutions. He has many years of experience with projects in the SAP BW area and is currently involved in several SAP BW projects in medium-size and large European companies.

Ralf Patrick Sawicki is an SAP BW consultant at CubeServ GmbH (Flörsheim am Main, Germany), which specializes in business intelligence solutions. He has many years of experience with SAP Business Information Warehouse and SAP R/3 and has been involved in numerous national and international projects with well-known companies. Ralf Patrick Sawicki is a certified solution consultant for SAP NetWeaver Business Intelligence.

Thomas Thielen is a senior consultant for business intelligence solutions at CubeServ AG (Jona, Switzerland). He holds a degree in Business Administration, Accounting, and Fiscal Law. In May 2002, SAP Europe certified Thomas Thielen as an Application Consultant for SAP Business Warehouse Systems. Since then he has managed and successfully implemented numerous projects with SAP BW and SAP SEM.