Sap Bw: A Step-By-Step Guide - Softcover

Fu, Biao Ph D; Fu, Henry P E

Softcover

ISBN 10: 0201703661 ISBN 13: 9780201703665

Publisher: Addison-Wesley Professional, 2002

Synopsis

A step-by-step guide to SAP's data warehousing tool, Business Information Warehouse (BW), the core part of SAP's next generation products. The CD contains all of the exclusive samples from the book.

About this title

About the Author

Biao Fu is a partner with Fuguji LLC, an IT consulting firm specialized in ERP, data warehousing, business intelligence, and supply chain management. Prior to Fuguji LLC, he was a principal consultant with PricewaterhouseCoopers (PwC). At PwC Global Training Center, he was a solutions architect, as well as the lead instructor of SAP BW Technical Infrastructure (BWTI) class, where he was granted the Award of Excellence for his contributions to BWTI and other BW classes. He is an SAP Certified Technical Consultant and SAP Certified BW Consultant.

Henry Fu is a partner with Fuguji LLC, an IT consulting firm specialized in ERP, data warehousing, business intelligence, and supply chain management. He is an Oracle Certified Database Administrator and Oracle Certified Application Developer. He has been involved in the development and implementation of several large-scale data warehousing projects. He is a licensed professional engineer (Ontario, Canada), and has two M.S. degrees majoring in management science and engineering.

0201703661AB01142003

From the Back Cover

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.

0201703661B07092002

Edition details

• Publisher: Addison-Wesley Professional
• Publication date: 2002
• Language: English
• ISBN 10: 0201703661
• ISBN 13: 9780201703665
• Binding: Paperback
• Number of pages: 320