SAP BW310官方教程：数据仓库入门指南

5星 · 超过95%的资源需积分: 9 59 浏览量更新于2024-07-27 1 收藏 33.8MB PDF 举报

"SAP BW310官方标准教程是一份针对SAP Business Warehouse (BW)的入门级教学材料，由SAP公司官方发布，适用于2005年第一季度版本。该课程为期5天，旨在通过50071083材料号的培训资源，帮助学习者理解和掌握数据仓库技术。课程内容包括SAP NetWeaver平台的基础知识，以及如何利用BW进行数据管理和分析。 SAP BW310是SAP NetWeaver架构下的关键组件，它作为一个企业级的数据仓库解决方案，帮助企业整合、处理和分析来自不同来源的复杂数据。通过这个教程，学员可以学习到如何设计、构建和维护数据模型，以及如何利用BW的工具如InfoProvider、InfoObjects和InfoCube进行数据展示和报告制作。教程提供了丰富的学习资源，如TrainingCenter，这是在线学习中心，包含了详细的教学内容和互动练习。Instructors是指课程的指导教师，他们具有丰富的实战经验和深厚的理论知识，能够确保学员获得高质量的培训。此外，教育网站可能包含课件、案例研究、实践作业等辅助资料，使学习过程更具系统性和深度。参加者需要遵循版权协议，未经SAP AG的明确许可，不得复制或传播这份教材的任何部分。课程内容可能会在没有事先通知的情况下进行更新，因此持续学习和关注最新版本至关重要。值得注意的是，SAP产品中可能包含来自其他软件供应商的专有软件组件，如Microsoft的SQL Server等，这些都属于各自公司的商标。 SAP BW310官方标准教程为想要进入数据仓库领域或提升相关技能的专业人士提供了一个全面且权威的学习路径，无论是初学者还是在职人员，都可以从中获取宝贵的知识和实践经验，以适应日益增长的数据驱动业务需求。"

Unit 1: Data Warehousing: Overview BW310

Lesson: SAP Business Information Warehouse

Lesson Overview

This lesson deals with the fundamental structures of the SAP Business Information

Warehouse (SAP BW). It also looks at how SAP BW is embedded in the SAP

landscape and its openness vis-a-vis external systems and databases.

Lesson Objectives

After completing this lesson, you will be able to:

• describe the fundamental structures of SAP BW.

• describe the architecture of SAP BW and mention its advantages.

• outline the different SAP OLAP tools

• explain the different options available to load data into SAP BW.

• explain how SAP BW is positioned as a component of mySAP Business Suite

and SAP Net Weaver.

Business Example

YouplantoimplementSAP BW as your ce ntral data warehouse. You need

a comprehensive overview of the structures and important terms in the SAP

BW system in order to be able to use the avaialble functions. You can use this

information to integrate SAP BW into your data processing world.

SAP Business Information Warehouse:Introduction

The SAP Business Information Warehouse (SAP BW) enables you to analyze

data from operative SAP applications and from other business applications and

external data sources such as databases, online services, and the Internet. SAP BW,

which is pre-configured for core areas and processes, allows you to examine the

relationships in all a reas of your organization.

The following needs were t aken into account when designing SAP BW:

• A data warehousing system with optimized data structures for reporting

and analysis

• A separate system

• OLAP engine and tools

• Based on a comprehensive data warehouse architecture

• Automated data warehouse management

• Preconfigured with SAP global business know-how

BW310 Lesson: SAP Business Information Warehouse

Source Sy stems

A s ource system is a system that provides the SAP BW system with data. SAP BW

distinguishes between four kinds of source systems:

• mySAP Business Suite components: SAP BW is fully integrated into the

mySAP Business Suite . It functions as a central data warehousing tool.

Predefined extraction structures and programs are de livered by SAP. These

allow source data from mySAP Business Suite components to be loaded

directly into the SAP BW system.

Complex organizational structures in which data from individual systems

is collected, create a need for a system architecture consisting of several

BW systems. These temporarily s tore data in the detailed form of an

organizational unit, before they can then be transferred to a central SAP BW

for carrying out comprehensive reporting.

• You can send data from SAP and non-SAP sources to SAP BW using SAP

Exchange Infrastructure (SAP XI). In SAP BW the data is placed in the

delta queue and is available there for further integration and consolidation.

Data transfer using SAP XI is SOAP-based. SAP XI is based on general

standards so as to enable external systems to be integrated. At the center of

the infrastructure is an XML-based communication that uses HTTP (Hyper

Text Transfer Protocol). The application-specific contents are transferred in

messages in user-defined XML (eXtensible Markup Language) schema from

the sender to the receiver using the Integration Server.

• Non-SAP systems: A big advantage of SAP BW lies in the fact that is has

an open architecture vis-a-vis external OLTP providers and other legacy

systems. Particularly in a heteroge nous system landscape, it is thus possible

to use SAP BW as a consolidated data basis for reporting that covers the

entire organization. SAP delivers various tools which allow these interfaces

to be implemented quickly and efficiently. These are looked at next.

• Data providers: As well being able to obtain data from a variety of

available systems, SAP BW can a lso be supplied with target-orientated data

from providers. For example, the organizations AC Nielsen US or Dun &

Bradstreet provide market research data, which can be loaded into SAP BW

for benchmarking and then measured against your own operative data. The

interface for the transfer of data supplied by the data providers is already

available in SAP BW. This means the d ata import can run smoothly.

• Databases: SAP BW allows data to be loaded from external relational

database systems. A DataSource is generated based on the external table

structure, enabling table content to be loaded quickly and consistently into

SAP BW.

剩余474页未读，继续阅读

corbinchan

粉丝: 0

SAP BW310官方教程：数据仓库入门指南

SAP BW305官方教程：入门企业报表与查询分析

SAP BW310初学者教程：企业数据仓储与BI实践

SAP BW官方教程：企业报表与分析

SAP BW标准教材310

SAP BW 经典教程

SAP BW7.0全套中文教程之——数据获取

SAP BW7.0全套中文教程之——集成计划

SAP BW7.0全套中文教程之——建模与实施

SAP BW7.0全套中文教程之——企业数据仓库

SAP BW4HANA标准建模指南.pdf

最新资源