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
- By Biao Fu, Henry Fu
- Published Jul 23, 2002 by Addison-Wesley Professional.
Book
- Sorry, this book is no longer in print.
About
Features
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
Description
- 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
Many large companies have now had SAP R/3 installed for several years, and have an urgent need to analyze the vast amounts of transaction data R/3 is providing them. Getting hold of vital facts and figures and turning them into useful information is a complex and time-consuming task. BW is designed to accurately and effectively support critical business decision-making. It facilitates high-performance and error-free extraction, transfer, transformation, and loading of data from a variety of data sources. This book uses step-by-step instructions with many examples to illustrate key SAP BW functions. Using a real-world business scenario as a running example, the book presents a comprehensive view of BW, from underlying concepts and basic techniques through the technology's most sophisticated capabilities. Tips, lessons, and best practices are discussed. It also covers other relevant technologies. With the clear explanations and practical techniques, SAP professionals will gain both the general understanding and specific skills they need to create effective data extraction tools needed to support decision-making processes.
Sample Content
Online Sample Chapter
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.)
Preface.
Acknowledgments.
I. GUIDED TOURS.
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.
Hierarchy.
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.
II. ADVANCED TOPICS.
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.Aggregates.
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.
Partition.
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
Preface
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.
Prerequisites
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.
0201703661P03142002
Index
Click below to download the Index file related to this title:
Index