Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Business Information Warehouse for SAP

Naeem Hashmi

467 pages, parution le 01/08/2000

Ajouter à une liste

Indisponible

Résumé

Benefit From the Author's Expertise
Gain an understanding of what it takes to implement SAP?BWTM. Follow along as the author explains the evolution of SAP BW architecture and its components. This book describes the roots of SAP BW and how it has evolved from a simple operational reporting environment to a full-featured information warehouse. Profit from a description of the structure of the SAP BW implementation team and SAP BW ASAP methodology. Learn how to construct data warehouses using BW based on the author's experiences during actual SAP BW implementations.

Master Data Warehouse Concepts
Learn basic data warehouse concepts?including the technical aspects and performance characteristics associated with constructing a data warehouse. Then, advance to a discussion of SAP BW architecture and how it compares with a traditional data warehouse. Learn what it takes to build analytical applications in SAP BW and the SAP BW development environment. Learn how metadata is managed in SAP BW and how SAP BW compares with data warehouse solutions provided by other vendors.

Contents

Introduction

Part I: Introduction to Data Warehousing and SAP Business Information Warehouse

Chapter 1: Constructing a Data Warehouse
In This Chapter
What Is Data Warehousing?

Business Intelligence
Data Warehouse Categories

Data Warehouse Architecture
Components of a Data Warehouse

Data Provider Layer
Service Provider Layer
Information Consumer Layer
Data Warehouse Management Layer

Technical Issues in Constructing a Data Warehouse

Global Information Delivery
Global Catalog
Metadata Management
Manageability
Adaption of New Technologies
Security
Reliability and Availability
Upgrading and Continual Improvements
Scalability and Data Distribution

Data Warehouse Performance Metrics
Evolution of ERP Data Warehousing
Summary

Chapter 2: Evolution of SAP Business Information Warehouse
In This Chapter
A Quick Look at SAP R/3 Architecture and Technologies
Reporting Environment in SAP R/3

Open Information Warehouse and Information Systems in SAP R/3
Logistics Information System (LIS)
Financial Information System
Executive Information System (EIS)
Comparing SAP R/3 Reporting Systems

Limitations of SAP R/3 Reporting
Strategies to Build SAP R/3-Centric Data Warehouse Environments

Database-Centric Data Warehouse
ALE-Centric Data Warehouse
Third-Party-Tool-Centric Data Warehouse

Evolution of Business Information Warehouse

Business Information Warehouse Architecture
Business Content in the Business Information Warehouse
Staging Engine
Data Access Using Business Explorer and OLAP Processor
Data Manager
BW OLAP Processor

Data Flow in BW
Sample SAP BW Report
Summary

Chapter 3: Comparing SAP BW with Data Warehouse Solutions Provided by Other Vendors
In This Chapter
Cultural Impact of ERP Data Warehousing

Data Warehouse and OLTP Teams
Data Warehouse Industry Analysts and Consulting Services
Providers

SAP Business Information Warehouse and Third-Party Data Warehouse Solutions
Summary

Chapter 4: Getting Started with SAP BW
In This Chapter
Log On to the SAP BW Administration Environment
Log On to the SAP BW Data Access Environment

Log On to the BEX Browser
Log On to the BEX Analyzer

Summary

Part II: Implementing SAP BW

Chapter 5: Planning for SAP BW Implementation
In This Chapter
Starting an SAP BW Project

Data Warehouse Implementation Methodologies

Top-Down Approach
Bottom-Up Approach
Hybrid Approach—SAP Approach

Planning for SAP BW

Initial Assessment—Making a Case for SAP BW
SAP BW Project Scope

Creating the SAP BW Project Team

Business Partners
Corporate Data Warehouse Program Office
SAP R/3 Program Office
SAP BW Experts
Corporate Information Architects and Technologists

Business Requirements
Technical Requirements
Summary

Chapter 6: Setting Up SAP BW
In This Chapter
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

Tools, Add-Ins, Browse

Initializing SAP BW Global Settings

Check Installation
SAP BW Active Client
Customizing the SAP BW Instance Configuration

Setting SAP BW Parameters in the RSADMIN Table

Installing SAP BW Extractors in the SAP R/3 OLTP Instance
Summary

Chapter 7: SAP BW—The Administrator Workbench
In This Chapter
SAP BW Administrator Workbench

SAP BW Content Delivery Functions of the Administrator Workbench

Source Systems

Defining an SAP R/3 as a Data Source System in SAP BW

InfoObjects

InfoObjects: Characteristics
General Metadata
Master Data and Text Tables
Hierarchies
InfoObject Attributes
Compounding
Key Figures
Time Characteristics
Unit of Measure Characteristics

Working with the InfoObjects Tree

Creating an InfoArea
Creating an InfoObject Catalog

InfoSources
InfoCubes

Viewing an InfoCube Data Model
Viewing an InfoCube Definition
Viewing InfoCube Content

Summary

Chapter 8: SAP BW—Loading Business Content
In This Chapter
Data Flow between SAP R/3 and SAP BW

Metadata Management in SAP R/3 OLTP
Metadata Management in SAP BW
Loading Metadata in SAP BW

Activating Business Content in SAP BW

Preparing the SAP BW Instance for Business Content
Enabling Business Content in SAP BW

Activating InfoObjects
Activating InfoObjectCatalogs
Activating InfoSources
Activating InfoCubes
Loading Queries for the InfoCubes from the Business Content
Activating Channels

Summary

Chapter 9: Preparing R/3 Data Source for SAP BW Initial Data Loads
In This Chapter
Preparing SAP R/3 for SAP BW

Information Collection Process in the SAP R/3 Data Source

Strategies to Prepare Initial Data Loads

Preparing Statistical Data in SAP R/3 for SAP Standard SD InfoCubes

Data Loading Strategies in SAP BW InfoCubes

Data Transfer Methods

Loading Data in Data Objects in SAP BW

Initial Data Loads
Delta Data Loads

Monitoring Data Loads
Summary

Chapter 10: Loading Data via Flat Files
In This Chapter
Non-SAP R/3 Data Source Loading Methods
Loading Data Using Flat Files

Flat File Scenario
Defining a Flat File Data Source in SAP BW
Defining Metadata for Flat Files
Data Type for Flat Files

Loading Data via Flat Files

Loading Data for Master Data Attributes
Loading Text and Hierarchy Data in SAP BW

Loading Transaction Data from Flat Files
Summary

Chapter 11: Analyzing SAP BW Data
In This Chapter
Business Explorer Architecture
Business Explorer Analyzer
Defining Queries

Customizing the Query Data Display Layout

Attaching a Chart
Navigating and Slicing and Dicing Data
Filters and Restricted Key Figures
Analyzing Data in the BEX Analyzer

Suppressing Repeated Key Values and Row Totals

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
In This Chapter
Data Warehouse Modeling

Data Modeling Considerations Specific to SAP BW

Multidimensional Data Modeling (MDM)

Defining Dimensions
Defining Facts

SAP BW Extended Multidimensional Data Model
Creating a New InfoCube in SAP BW

Building an InfoCube

Defining InfoCube Data Structures
Assigning Characteristics to Dimensions

Defining Update Rules for an InfoCube

Joining InfoCubes

Defining a MultiCube InfoCube in SAP BW 2.0A

Summary

Chapter 13: Enhancing Business Content and Developing Data Extractors
In This Chapter
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
In This Chapter
SAP BW Data Load Interface

Staging BAPIs for SAP BW
Using Staging BAPIs to Architect Data Loading for SAP BW

Metadata Management
Extract and Send Data to SAP BW

Implementing Informatica's PowerCenter to Load Data in SAP BW

Create Data Source Definitions for PowerCenter in SAP BW

Defining an RFC Connection in SAP BW for Informatica PowerCenter
Connecting the PowerCenter Integration Server to SAP BW

Importing the SAP BW InfoSource in PowerCenter
Defining an SAP BW Connection in the PowerCenter Server Manager

Loading Data in SAP BW

Start PowerCenter Integration Server for SAP BW
Schedule Data Load Jobs from SAP BW Scheduler
Other Third-Party Staging BAPI Implementations

Summary

Chapter 15: Integrating Third-Party Data Access Products with SAP BW
In This Chapter
Data Access Interfaces for SAP BW
SAP BW Open Data Access Strategy

OLE DB for OLAP Architecture (ODBO)

Installing ODBO Components at the Client Workstation
Accessing Data from Third-Party Tools

Setting Up the inSight Development Environment
Building an inSight Application

ODBO and BAPIs in SAP BW 2.0
Summary

Chapter 16: Managing SAP BW—Performance and Sizing Tuning
In This Chapter
SAP BW Performance

Optimizing Data Loads in SAP BW
Index Management
Buffering Number Range Objects
InfoCube Aggregates

Defining InfoCube Aggregates

SAP BW Query Optimization

Read All Data
Read Data during Navigation
Read Data during Navigation and When Expanding the Hierarchy
Setting Up Query Read Modes

Sizing SAP BW

The Sizing Process

SAP BW Benchmark
Sizing SAP BW Components

Summary

Chapter 17: The Operational Data Store in SAP BW 2.0
In This Chapter
What Is an Operational Data Store (ODS)?

History of Operational Data Store

SAP BW 2.0A ODS Architecture

Persistent Staging Area
ODS Operating Environment

Building ODS Objects

Creating an ODS Table and Updated Rules
Accessing Data from ODS and Setting Up a Drill-Down Scheme

Drill Down to ODS from an InfoCube
Building ODS in SAP BW 2.0B

Creating ODS Objects 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
In This Appendix
Books on Data Warehousing

Data Warehousing Reference Books
SAP Reference Books

Data Warehouse Industry Reference Web Sites

Data Warehouse Magazine and Literature Web Sites
Data Warehouse Consulting Services Web Sites
Data Warehouse Product Vendor Web Sites

SAP BW Training Courses

BW200: Business Information Warehouse

(BW)-Overview

BW205: Business Information Warehouse

(BW)-Analysis

BW210: Business Information Warehouse

(BW)-System Configuration

BW220: Business Information Warehouse

(BW)-SAP OLTP Extraction

D20BW: Business Information Warehouse

(BW)-Delta with Release 2.0

SAP BW ODBO-Certified Products
SAP BW Staging BAPI-Certified Products

Appendix B: SAP BW and SAP R/3 Transactions, Tables, and Code Examples
In This Appendix
SAP BW 1.2B Programs in the SAP R/3 OLTP Instance

Data Extractors
LIS Setup

SAP BW Tables

Key Tables in SAP R/3 OLTP
Function Modules on SAP R/3 OLTP for LIS Extracts
Tables in SAP BW 1.2B
Transactions of SAP BW

InfoCube Update Code Examples

Appendix C: Selected SAP BW OSS Notes
In This Appendix
Basis Notes
Business Content
General Purpose
Reporting and Analysis
Warehouse Management

Appendix D: Key Enhancements in SAP BW 2.0
In This Appendix
SAP BW 2.0B Architecture

The ROLAP Implementation—Star Schema Model
InfoSources and Data Sources in SAP BW
The Administrator Workbench
The Operational Data Store (ODS)
Business Document Services (BDS)

Web Reporting

SAP Web Reporting Architecture
Publishing Dynamic SAP BW Reports Over the Internet

Business Explorer Browser
Reference
Summary

Appendix E: What's on the CD-ROM

Index

L'auteur - Naeem Hashmi

Naeem Hashmi, a widely known expert in the ERP business intelligence industry and pioneer in ERP data warehousing, has more than 22 years of experience in emerging Information Technologies research, development, and management covering such technologies as information delivery architecture; e-business; ERP applications; data warehousing; data mining; CRM; database, Web, object and client/server technologies; enterprise application integration; and information architectures. He is the chief technology officer of Information Frameworks, an emerging Information Technology research and strategic IT consulting group. A former technical director at Compaq/Digital, he directed early SAP BW customer projects for the Benchmark and Engineering Group, and has worked directly with SAP management and engineering team members in defining requirements and architecture for SAP BW.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prima Publishing
Auteur(s)	Naeem Hashmi
Parution	01/08/2000
Nb. de pages	467
Format	19 x 24
Couverture	Relié
Poids	1208g
Intérieur	Noir et Blanc
EAN13	9780761523352