文档介绍:仪征化纤SAP BW培训
1
FACT
Dimension table
Text
SID Table
Master
Hierarchy
Text
SID Table
Master
Hierarchy
Text …
13970522 west ...
P C T Quantity Revenue Discount Sales overhead
250 500,000 $ 50,000 $ 280,000 $
50 100,000 $ 7,500 $ 60,000 $
… … … ...
时间维度
产品维度
T Period Fiscal year …
04 2000 ...
P Product # Product group …
2101004 displays ...
事实表
客户维度
星型结构
事实表和维度表的组合被称之为星型结构The
Transfer Rules
数据抽取
Update Rules
InfoCubes
Communication structure
Transfer Structure
Extract Source Structure
Business Information
Warehouse Server
Staging Engine
OLTP Source System 1
OLTP Source System 2
Extract Source Structure
Transfer Structure
Transfer Structure
Transfer Structure
Extract Source Structure
Transfer Structure
数据源
Transfer Structure
信息源
Transfer Rules
Transfer Rules
数据抽取方式
Communication- structure
Update rules
Transfer-structure
PSA
IDOC
TRFC
255 fields, 1026 bytes
1000 bytes
BAPI
file
Third party
Length 250 +additional segments
A PSA for eachTransfer structure
BAPI
R/3connection
Transfer rules
apply
Transfer
Rules
Extraction method
chosen in transfer
structure
管理员工作台
SAP BW对系统管理的核心组件
监控数据传输
计划和运行数据抽取
数据仓库设计,维护和管理
Admin.
Workbench
SAP Business Explorer
使用 BEx Analyzer创建查询
New Query
InfoCube
Zeilen
Filter
Freie Merkmale
Columns
New Query
InfoCubes for new query
Accounts rec. acc.
FIAR transaction data
Asset Accounting
Annual values
Annual values and tr
. . . .
Find:
Cancel
OK
Right
Technical name
Local search
SAP BEx: Choose Query
Cancel
Open
Available objects
Sales and distribution
Customer
Credit memos
Customer incoming...
Purchasing
Purchasing data
Find
Definition
New query
2
1
选择特性和关键指标
New Query
Filter
User-def. char.
FIAR Transaction data
Key figures
Accumulated balance
Total credit postings
Total debit postings
Sales volume in period
Dimensions
Customer