儀征化纖SAP BW培訓(xùn)ppt課件

1、儀征化纖SAP BW培訓(xùn)SAP BW 組件SAP BW 星型構(gòu)造數(shù)據(jù)抽取業(yè)務(wù)內(nèi)容 業(yè)務(wù)分析器內(nèi)容:BW 概述信息需求報表和數(shù)據(jù)分析各種層次的細(xì)節(jié)數(shù)據(jù)各種類型的用戶數(shù)據(jù)源不同的硬件平臺不同的軟件平臺不同的數(shù)據(jù)源系統(tǒng)數(shù)據(jù)倉庫的構(gòu)造業(yè)務(wù)信息倉庫效力器管理員平臺BAPIOLAP processorStaging EngineInfoCubesMeta DataRepositoryODS業(yè)務(wù)閱讀器BAPIclientSAP BW 構(gòu)造Web 報表第三方工具數(shù)據(jù)源PSABusiness Information Warehouse R/3 other強(qiáng)勁的信息分析- 友好的用戶界面- 強(qiáng)有力的OLAP 分析

2、功能- 為各種類型的用戶提供支持- 基于角色的權(quán)限管理豐富的業(yè)務(wù)內(nèi)容大量的信息模型報表信息對象數(shù)據(jù)抽取工具全方位的數(shù)據(jù)倉庫處理方安- 可以集成R/3 和非R/3數(shù)據(jù)- 高度自動化處置- 實(shí)施快速數(shù)據(jù)的集中保管地包含兩方面的信息關(guān)鍵目的 Key figures特性 Characteristics1 現(xiàn)實(shí)表 和16 個維度表3 維度 是SAP系統(tǒng)自動維護(hù)的TimeUnitInfo packageInfoCube什么是 InfoObject ?InfoObject “0COSTCENTERInfoObjects就有獨(dú)一性，是跨業(yè)務(wù)組件的R/3 OLTPCOControllingHRHuman Res

3、ourcesTable of cost centers Table of employees各種不同的OLTP數(shù)業(yè)務(wù)對象、數(shù)據(jù)字段在BW中被預(yù)先定義為InfoObjectFACTDimension tableTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchy

4、TextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyTextSID TableMasterHierarchyDimension tableDimension tableDimension tableDimension tableSAP BW: 擴(kuò)展的星型構(gòu)造P C T QuantityRevenueDiscountSales overhead 250500,000 $50,000 $280,000 $50100,000 $7,500 $60,000 $.Fact table現(xiàn)實(shí)表

5、現(xiàn)實(shí)表中的每一個記錄都有是經(jīng)過維度表中的KEY獨(dú)一確定的現(xiàn)實(shí)表在上傳業(yè)務(wù)數(shù)據(jù)時被維護(hù)Time dimensionProduct dimensionCustomer dimensionP Product # Product group 2101004 Displays.C Customer # Region 70522 West .T PeriodFiscal year 042000.維度維度表的鍵在現(xiàn)實(shí)表中被作為外鍵在維度表中包含主鍵，維度號碼和特性C Customer # Region 70522 west .PCTQuantityRevenueDiscountSales overhead

6、250500,000 $50,000 $280,000 $50100,000 $7,500 $60,000 $.時間維度產(chǎn)品維度T Period Fiscal year 04 2000 .PProduct # Product group 2101004 displays .現(xiàn)實(shí)表客戶維度星型構(gòu)造現(xiàn)實(shí)表和維度表的組合被稱之為星型構(gòu)造TheTransfer Rules數(shù)據(jù)抽取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數(shù)據(jù)源Transfer Structure信息源Transfer RulesTransfer Rules數(shù)據(jù)抽取方式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管理員任務(wù)臺SAP BW對系統(tǒng)管理的中心組件監(jiān)控?cái)?shù)據(jù)傳輸方案和運(yùn)轉(zhuǎn)數(shù)據(jù)抽取數(shù)據(jù)倉庫設(shè)計(jì)，維護(hù)和管理Admin.Workbench角色Common Meta data業(yè)務(wù)內(nèi)

9、容信息立方體信息源和數(shù)據(jù)抽取接口查詢RevenueProduct信息對象任務(wù)簿業(yè)務(wù)內(nèi)容SAP Business Explorer運(yùn)用 BEx Analyzer創(chuàng)建查詢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選擇特性和關(guān)鍵目的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