仪征化纤SAP BW培训

《仪征化纤SAP BW培训》由会员分享，可在线阅读，更多相关《仪征化纤SAP BW培训（19页珍藏版）》请在装配图网上搜索。

1、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,Inf

2、oCubes,Meta DataRepository,ODS,业务浏览器,BAPI,client,SAP BW,结,结构,Web 报表,第三方工具,数据源,PSA,Business InformationWarehouse,R/3,other,强劲的信息分析,-友好的用户,界,界面,-强有力的OLAP 分析功,能,能,-为各种类型,的,的用户提供支持,-基于角色的,权,权限管理,丰富的业务内容,大量的信息模型,报表,信息对象,数据抽取工具,全方位的数据仓,库,库解决方安,-能够集成R/3 和非R/3数据,-高度自动化,处,处理,-实施快速,数据的集中保存,地,地,包含两方面的信,息,息,关键指

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中被预先,定,定

4、义为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 T

5、able,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,事实表,事实表中的每一,个,个记录都有是通,

6、过,过维度表中的KEY唯一确定的,事实表在上传业,务,务数据时被维护,Time dimension,Productdimension,Customer dimension,P Product#Product group,2101004 Displays.,C Customer#Region ,13970522 West .,T PeriodFiscal year,042000.,维度,维度表,的,的键在,事,事实表,中,中被作,为,为外键,在维度,表,表中包,含,含主键,，,，维度,号,号码和,特,特性,CCustomer#Region,13970522west.,PCTQuantityRev

7、enueDiscountSales overhead,250500,000$50,000$280,000$,50100,000$7,500$60,000$,.,时间维,度,度,产品维,度,度,TPeriodFiscalyear,042000.,PProduct#Productgroup,2101004displays.,事实表,客户,维,维度,星型,结,结构,事实,表,表和,维,维度,表,表的,组,组合,被,被称,之,之为,星,星型,结,结构The,TransferRules,数据,抽,抽取,UpdateRules,InfoCubes,Communicationstructure,Transf

8、erStructure,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,TransferRu

9、les,数据,抽,抽取,方,方式,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,

10、管理员工作,台,台,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 ne

11、w 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,Defin

12、ition,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

13、,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 processin

14、g,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 概述:,总,总结,