儀征化纖SAPBW培訓(xùn)SAPBW組件SAPBW星型結(jié)構(gòu)數(shù)據(jù)抽取業(yè)務(wù)內(nèi)容業(yè)務(wù)分析器內(nèi)容:BW概述信息需求 報(bào)表和數(shù)據(jù)分析 各種層次的細(xì)節(jié)數(shù)據(jù) 各種類型的用戶數(shù)據(jù)源 不同的硬件平臺(tái) 不同的軟件平臺(tái) 不同的數(shù)據(jù)源系統(tǒng)數(shù)據(jù)倉(cāng)庫(kù)的結(jié)構(gòu)業(yè)務(wù)信息倉(cāng)庫(kù)

服務(wù)器管理員平臺(tái)BAPIOLAPprocessorStagingEngineInfoCubesMetaData

RepositoryODS業(yè)務(wù)瀏覽器BAPI

clientSAPBW結(jié)構(gòu)Web報(bào)表第三方工具數(shù)據(jù)源PSABusinessInformationWarehouseR/3other強(qiáng)勁的信息分析-友好的用戶界面-強(qiáng)有力的OLAP分析功能-為各種類型的用戶提供支持-基于角色的權(quán)限管理豐富的業(yè)務(wù)內(nèi)容大量的信息模型報(bào)表信息對(duì)象數(shù)據(jù)抽取工具全方位的數(shù)據(jù)倉(cāng)庫(kù)解決方安-能夠集成R/3和非R/3數(shù)據(jù)-高度自動(dòng)化處理-實(shí)施快速數(shù)據(jù)的集中保存地包含兩方面的信息關(guān)鍵指標(biāo)（Keyfigures）特性（Characteristics）1事實(shí)表和16個(gè)維度表3維度是SAP系統(tǒng)自動(dòng)維護(hù)的TimeUnitInfopackageInfoCube什么是InfoObject?InfoObject“0COSTCENTER”InfoObjects就有唯一性，是跨業(yè)務(wù)組件的R/3OLTPCOControllingHRHumanResourcesTableofcostcenters

Tableofemployees各種不同的OLTP數(shù)（業(yè)務(wù)對(duì)象、數(shù)據(jù)字段）在BW中被預(yù)先定義為InfoObjectFACTDimensiontableTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyTextSIDTableMasterHierarchyDimensiontableDimensiontableDimensiontableDimensiontableSAPBW:擴(kuò)展的星型結(jié)構(gòu) P C T Quantity Revenue Discount Salesoverhead 250 500,000$ 50,000$ 280,000$ 50 100,000$ 7,500$ 60,000$ … … … ...Facttable事實(shí)表事實(shí)表中的每一個(gè)記錄都有是通過(guò)維度表中的KEY唯一確定的事實(shí)表在上傳業(yè)務(wù)數(shù)據(jù)時(shí)被維護(hù)TimedimensionProductdimensionCustomerdimensionP Product#Productgroup … 2101004Displays ...C Customer# Region … 13970522 West ...T Period Fiscalyear … 04 2000 ...維度維度表的鍵在事實(shí)表中被作為外鍵在維度表中包含主鍵，維度號(hào)碼和特性CCustomer#Region……13970522west...P CTQuantityRevenue Discount Salesoverhead250500,000$ 50,000$ 280,000$50100,000$7,500$60,000$… ………...時(shí)間維度度產(chǎn)品維度度TPeriodFiscalyear……042000...P Product#Productgroup……2101004displays...事實(shí)表客戶維度度星型結(jié)構(gòu)構(gòu)事實(shí)表和和維度表表的組合合被稱之之為星型型結(jié)構(gòu)TheTransferRules數(shù)據(jù)抽取取UpdateRulesInfoCubesCommunicationstructureTransferStructureExtractSourceStructureBusinessInformationWarehouseServerStagingEngineOLTPSourceSystem1OLTPSourceSystem2ExtractSourceStructureTransferStructureTransferStructureTransferStructureExtractSourceStructureTransferStructure數(shù)據(jù)源TransferStructure信息源TransferRulesTransferRules數(shù)據(jù)抽取取方式Communication-structureUpdaterulesTransfer-structurePSAIDOCTRFC255fields,1026bytes1000bytesBAPIfileThirdpartyLength250+additionalsegmentsAPSAforeachTransferstructureBAPIR/3connectionTransferrulesapplyTransferRulesExtractionmethodchosenintransferstructure管理員工工作臺(tái)SAPBW對(duì)系統(tǒng)管管理的核核心組件件監(jiān)控?cái)?shù)據(jù)據(jù)傳輸計(jì)劃和運(yùn)運(yùn)行數(shù)據(jù)據(jù)抽取數(shù)據(jù)倉(cāng)庫(kù)庫(kù)設(shè)計(jì)，，維護(hù)和和管理Admin.Workbench角色CommonMetadata業(yè)務(wù)內(nèi)容容信息立方方體信息源和和數(shù)據(jù)抽抽取接口口查詢RevenueProduct信息對(duì)象工作簿業(yè)務(wù)內(nèi)容容SAPBusinessExplorer使用BExAnalyzer創(chuàng)創(chuàng)建查詢?cè)僋ewQueryInfoCubeZeilenFilterFreieMerkmaleColumnsNewQueryInfoCubesfornewqueryAccountsrec.acc.FIARtransactiondataAssetAccountingAnnualvaluesAnnualvaluesandtr....Find:CancelOKRightTechnicalnameLocalsearchSAPBEx:ChooseQueryCancelOpenAvailableobjectsSalesanddistributionCustomerCreditmemosCustomerincoming...PurchasingPurchasingdataFindDefinitionNewquery21選擇特性性和關(guān)鍵鍵指標(biāo)NewQueryFilterUser-def.char.FIARTransactiondataKeyfiguresAccumulatedbalanceTotalcreditpostingsTotaldebitpostingsSalesvolumeinperiodDimensionsCustomerSectorCustomernumberCountryCompanycodeCurrencytypeTimeUnitRowsCust...ColumnsStructureAccumulatedb.Accumul.CustomersCustomersOLTPVs.OLAP特性PrimaryOperationLevelofAnalysisAmountofdatapertransactionTypeofdataTimelinessofdataUpdatestodataDatabasedesignNumberoftransactions/usersResponsetimeDatabasedataNumberoftablespertransactionTypeofprocessingOLTPUpdateLowVerysmallDetailedMustbecurrentFrequentlyComplexMany(100sto1000s)QuickNormalizedSeveralWelldefinedOLAPAnalyzeHighVerylargeSummaryCurrentandhistorical