仪征化纤SAP BW培训ppt课件

1、仪征化纤SAP BW培训SAP BW 组件SAP BW 星型构造数据抽取业务内容 业务分析器内容:BW 概述信息需求报表和数据分析各种层次的细节数据各种类型的用户数据源不同的硬件平台不同的软件平台不同的数据源系统数据仓库的构造业务信息仓库效力器管理员平台BAPIOLAP processorStaging EngineInfoCubesMeta DataRepositoryODS业务阅读器BAPIclientSAP BW 构造Web 报表第三方工具数据源PSABusiness Information Warehouse R/3 other强劲的信息分析- 友好的用户界面- 强有力的OLAP 分析

2、功能- 为各种类型的用户提供支持- 基于角色的权限管理丰富的业务内容大量的信息模型报表信息对象数据抽取工具全方位的数据仓库处理方安- 可以集成R/3 和非R/3数据- 高度自动化处置- 实施快速数据的集中保管地包含两方面的信息关键目的 Key figures特性 Characteristics1 现实表 和16 个维度表3 维度 是SAP系统自动维护的TimeUnitInfo packageInfoCube什么是 InfoObject ?InfoObject “0COSTCENTERInfoObjects就有独一性，是跨业务组件的R/3 OLTPCOControllingHRHuman Res

3、ourcesTable of cost centers Table of employees各种不同的OLTP数业务对象、数据字段在BW中被预先定义为InfoObjectFACTDimension tableTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchy

4、TextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyDimension tableDimension tableDimension tableDimension tableSAP BW: 扩展的星型构造P C T QuantityRevenueDiscountSales overhead 250500,000 $50,000 $280,000 $50100,000 $7,500 $60,000 $.Fact table现实表

5、现实表中的每一个记录都有是经过维度表中的KEY独一确定的现实表在上传业务数据时被维护Time dimensionProduct dimensionCustomer dimensionP Product # Product group 2101004 Displays.C Customer # Region 70522 West .T PeriodFiscal year 042000.维度维度表的键在现实表中被作为外键在维度表中包含主键，维度号码和特性C Customer # Region 70522 west .PCTQuantityRevenueDiscountSales overhead

6、250500,000 $50,000 $280,000 $50100,000 $7,500 $60,000 $.时间维度产品维度T Period Fiscal year 04 2000 .PProduct # Product group 2101004 displays .现实表客户维度星型构造现实表和维度表的组合被称之为星型构造TheTransfer Rules数据抽取Update RulesInfoCubesCommunication structureTransfer StructureExtract Source StructureBusiness InformationWarehou

7、se ServerStaging EngineOLTP Source System 1OLTP Source System 2Extract Source StructureTransfer StructureTransfer StructureTransfer StructureExtract Source StructureTransfer Structure数据源Transfer Structure信息源Transfer RulesTransfer Rules数据抽取方式Communication- structureUpdate rulesTransfer-structurePSAID

8、OCTRFC255 fields, 1026 bytes1000 bytesBAPIfileThird partyLength 250 +additional segmentsA PSA for eachTransfer structureBAPIR/3connectionTransfer rules applyTransfer RulesExtraction methodchosen in transferstructure管理员任务台SAP BW对系统管理的中心组件监控数据传输方案和运转数据抽取数据仓库设计，维护和管理Admin.Workbench角色Common Meta data业务内

9、容信息立方体信息源和数据抽取接口查询RevenueProduct信息对象任务簿业务内容SAP Business Explorer运用 BEx Analyzer创建查询New QueryInfoCubeZeilenFilterFreie MerkmaleColumnsNew QueryInfoCubes for new queryAccounts rec. acc.FIAR transaction dataAsset AccountingAnnual valuesAnnual values and tr. . . .Find:CancelOKRight Technical name Local

10、search SAP BEx: Choose QueryCancelOpenAvailable objectsSales and distributionCustomerCredit memosCustomer incoming.PurchasingPurchasing dataFindDefinitionNew query21选择特性和关键目的New QueryFilterUser-def. char.FIAR Transaction dataKey figuresAccumulated balanceTotal credit postingsTotal debit postingsSale

11、s volume in periodDimensionsCustomerSectorCustomer numberCountryCompany codeCurrency typeTimeUnitRowsCust.ColumnsStructureAccumulated b.Accumul.CustomersCustomersOLTP Vs. OLAP特性Primary OperationLevel of AnalysisAmount of data per transactionType of dataTimeliness of dataUpdates to dataDatabase designNumber of transactions/usersResponse timeDatabase dataNumber of tables per transactionType of processingOLTPUpdateLowVery smallDetailedMust be current FrequentlyComplexMany (100s to 1000s)QuickNormalizedSeveralWell definedOLAPAnalyz