Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,仪征化纤SAP BW培训,SAP BW,组,组件,SAP BW,星,星型结构,数据抽取,业务内容,业务分析器,内容,:,BW 概述,信息需求,报表和数据分析,各种层次的细节,数,数据,各种类型的用户,数据源,不同的硬件平台,不同的软件平台,不同的数据源系,统,统,数据仓库的结构,业务信息仓库,服,服务器,管理员平台,BAPI,OLAP processor,StagingEngine,InfoCubes,Meta DataRepository,ODS,业务浏览器,BAPI,client,SAP BW,结,结构,Web 报表,第三方工具,数据源,PSA,Business InformationWarehouse,R/3,other,强劲的信息分析,-友好的用户,界,界面,-强有力的OLAP 分析功,能,能,-为各种类型,的,的用户提供支持,-基于角色的,权,权限管理,丰富的业务内容,大量的信息模型,报表,信息对象,数据抽取工具,全方位的数据仓,库,库解决方安,-能够集成R/3 和非R/3数据,-高度自动化,处,处理,-实施快速,数据的集中保存,地,地,包含两方面的信,息,息,关键指标,（,Key figures,）,特性（,Characteristics,）,1,事实表 和,16,个维度表,3,维度 是,SAP,系统自动维护的,Time,Unit,Info package,InfoCube,什么是 InfoObject?,InfoObject,“0COSTCENTER”,InfoObjects就有唯,一,一性，是跨业务,组,组件的,R/3 OLTP,CO,Controlling,HR,Human,Resources,Table of costcenters,Table of employees,各种不同的OLTP数（业务对,象,象、数据字段）,在,在BW中被预先,定,定义为InfoObject,FACT,Dimension table,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Text,SID Table,Master,Hierarchy,Dimension table,Dimension table,Dimension table,Dimension table,SAP BW:,扩,扩展的星型结,构,构,P C TQuantityRevenueDiscountSales overhead,250500,000$50,000$280,000$,50100,000$7,500$60,000$,.,Fact table,事实表,事实表中的每一,个,个记录都有是通,过,过维度表中的KEY唯一确定的,事实表在上传业,务,务数据时被维护,Time dimension,Productdimension,Customer dimension,P Product#Product group,2101004 Displays.,C Customer#Region ,13970522 West .,T PeriodFiscal year,042000.,维度,维度表,的,的键在,事,事实表,中,中被作,为,为外键,在维度,表,表中包,含,含主键,，,，维度,号,号码和,特,特性,CCustomer#Region,13970522west.,PCTQuantityRevenueDiscountSales overhead,250500,000$50,000$280,000$,50100,000$7,500$60,000$,.,时间维,度,度,产品维,度,度,TPeriodFiscalyear,042000.,PProduct#Productgroup,2101004displays.,事实表,客户,维,维度,星型,结,结构,事实,表,表和,维,维度,表,表的,组,组合,被,被称,之,之为,星,星型,结,结构The,TransferRules,数据,抽,抽取,UpdateRules,InfoCubes,Communicationstructure,TransferStructure,Extract Source Structure,BusinessInformation,WarehouseServer,StagingEngine,OLTPSourceSystem1,OLTPSourceSystem2,Extract Source Structure,Transfer Structure,Transfer Structure,Transfer Structure,Extract Source Structure,Transfer Structure,数据源,Transfer Structure,信息源,TransferRules,TransferRules,数据,抽,抽取,方,方式,Communication-structure,Updaterules,Transfer-structure,PSA,IDOC,TRFC,255fields,1026bytes,1000bytes,BAPI,file,Thirdparty,Length 250+additional segments,A PSAforeachTransfer structure,BAPI,R/3,connection,Transfer rules,apply,Transfer,Rules,Extractionmethod,chosen intransfer,structure,管理员工作,台,台,SAP,BW,对系统管理,的,的核心组件,监控数据传,输,输,计划和运,行,行数据抽,取,取,数据仓库,设,设计，维,护,护和管理,Admin.,Workbench,角色,Common Metadata,业务内容,信息立方,体,体,信息源和数据,抽,抽取接口,查询,Revenue,Product,信息对象,工作簿,业务内容,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:ChooseQuery,Cancel,Open,Availableobjects,Salesanddistribution,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,Sector,Customer number,Country,Companycode,Currency type,Time,Unit,Rows,Cust.,Columns,Structure,Accumulated b.,Accumul.,Customers,Customers,OLTP Vs,.OLAP,特性,Primary Operation,Level of Analysis,Amount of data per transaction,Type of data,Timeliness of data,Updates to data,Database design,Number of transactions/users,Response time,Database data,Number of tables per transaction,Type of processing,OLTP,Update,Low,Very small,Detailed,Must be current,Frequently,Complex,Many(100s to 1000s),Quick,Normalized,Several,Well defined,OLAP,Analyze,High,Very large,Summary,Current and historical,Less frequent,new data only,Simple,Few,Reasonable,Denormalized,Few,Ad hoc,描述BW的主要,结,结构和组件,描述BW的星型,结,结构,能够描述数据如,何,何从源系统进入BW系统,了解业务内容的,目,目的,创建最基本的查,询,询,你现在能够,:,BW 概述:,总,总结,