Business Information Warehouse for SAP (Prima Techs SAP Book Series)

ISBN: 0761523359
EAN: 2147483647

Year: 1999
Pages: 174

Authors: Naeem Hashmi

BUY ON AMAZON

Table of Contents
BackCover
Business Information Warehouse for SAP-Your Guide to Data Warehousing and BW
Foreword
Introduction
How to Use this Book
How this Book is Organized
Part 1: Data Warehousing and SAP BW
Part 2: Implementing SAP BW
Part 3: Designing Custom SAP BW OLAP Solutions
Part 4: Appendixes
Part I: Introduction to Data Warehousing and SAP Business Information Warehouse
Chapter 1: Constructing a Data Warehouse
Data Warehouse Architecture
Components of a Data Warehouse
Technical Issues in Constructing a Data Warehouse
Data Warehouse Performance Metrics
Evolution of ERP Data Warehousing
Summary
Chapter 2: Evolution of SAP Business Information Warehouse
Reporting Environment in SAP R3
Limitations of SAP R3 Reporting
Strategies to Build SAP R3-Centric Data Warehouse Environments
Evolution of Business Information Warehouse
Data Flow in BW
Sample SAP BW Report
Summary
Chapter 3: Comparing SAP BW with Data Warehouse Solutions Provided by Other Vendors
SAP Business Information Warehouse and Third-Party Data Warehouse Solutions
Summary
Chapter 4: Getting Started with SAP BW
Log On to the SAP BW Administration Environment
Log On to the SAP BW Data Access Environment
Summary
Part II: Implementing SAP BW
Chapter 5: Planning for SAP BW Implementation
Starting an SAP BW Project
Creating the SAP BW Project Team
Business Requirements
Technical Requirements
Summary
Chapter 6: Setting Up SAP BW
Getting Ready for SAP BW Software Installation
Installing and Configuring SAP BW Servers
Configuring the SAP BW Administrator Workstation
Installing Frontend Components for End-User Reporting and Analysis
Initializing SAP BW Global Settings
Installing SAP BW Extractors in the SAP R3 OLTP Instance
Summary
Chapter 7: SAP BW-The Administrator Workbench
SAP BW Administrator Workbench
Summary
Chapter 8: SAP BW-Loading Business Content
Data Flow between SAP R3 and SAP BW
Activating Business Content in SAP BW
Summary
Chapter 9: Preparing R3 Data Sources for SAP BW Initial Data Loads
Preparing SAP R3 for SAP BW
Strategies to Prepare Initial Data Loads
Data Loading Strategies in SAP BW InfoCubes
Loading Data in Data Objects in SAP BW
Monitoring Data Loads
Summary
Chapter 10: Loading Data via Flat Files
Non-SAP R3 Data Source Loading Methods
Loading Data using Flat Files
Loading Data via Flat Files
Loading Transaction Data From Flat Files
Summary
Chapter 11: Analyzing SAP BW Data
Business Explorer Architecture
Business Explorer Analyzer
Defining Queries
Attaching a Chart
Navigating and Slicing and Dicing Data
Filters and Restricted Key Figures
Analyzing Data in the BEX Analyzer
Use of Variables in BEX Analyzer Queries
The InfoCatalog
The Business Explorer Browser
Summary
Part III: Designing Custom SAP BW OLAP Solutions
Chapter 12: SAP BW-Defining Custom InfoCubes
Data Warehouse Modeling
Multidimensional Data Modeling (MDM)
SAP BW Extended Multidimensional Data Model
Creating a New InfoCube in SAP BW
Joining InfoCubes
Summary
Chapter 13: Enhancing Business Content and Developing Data Extractors
Enhancing Business Content
Extending Transaction Data Content
Extending Master Data InfoSource Content
Extending Texts InfoSource
Debugging Data Extractors
Summary
Chapter 14: Integrating Third-Party ETL Products with SAP BW
SAP BW Data Load Interfaces
Implementing Informatica s PowerCenter to Load Data in SAP BW
Summary
Chapter 15: Integrating Third-Party Data Access Products with SAP BW
Data Access Interfaces for SAP BW
SAP BW Open Data Access Strategy
Installing ODBO Components at the Client Workstation
Accessing Data From Third-Party Tools
ODBO and BAPIs in SAP BW 2.0
Summary
Chapter 16: Managing SAP BW-Performance and Sizing Tuning
SAP BW Performance
SAP BW Query Optimization
Sizing SAP BW
Summary
Chapter 17: The Operational Data Store in SAP BW 2.0
SAP BW 2.0A ODS Architecture
Building ODS Objects
Drill Down to ODS From an InfoCube
Building ODS in SAP BW 2.0B
Future Direction of ODS in SAP BW
Summary
Part IV: Appendixes
Appendix A: Data Warehouse Industry References and SAP BW Training
Books on Data Warehousing and SAP Technologies
Data Warehouse Industry Reference Web Sites
SAP BW Training Courses
SAP BW ODBO-Certified Products
SAP BW Staging BAPI-Certified Products
Appendix B: SAP BW and SAP R3 Transactions, Tables, and Code Examples
SAP BW 1.2B Programs in the SAP R3 OLTP Instance
SAP BW Tables
InfoCube Update Code Examples
Appendix C: Selected SAP BW OSS Notes
Basis Notes
Business Content
General Purpose
Reporting and Analysis
Warehouse Management
Appendix D: Key Enhancements in SAP BW 2.0
SAP BW 2.0B Architecture
Web Reporting
Business Explorer Browser
Reference
Summary
Appendix E: What s on the CD-ROM
The Prima License
The Prima User Interface
Index
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
Index_Z
List of Figures
List of Tables