儀征化纖SAPBW培訓(xùn)

儀征化纖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ù)倉庫的結(jié)構(gòu),業(yè)務(wù)信息倉庫服務(wù)器,管理員平臺(tái),OLAPprocessor,StagingEngine,MetaDataRepository,業(yè)務(wù)瀏覽器,SAPBW結(jié)構(gòu),Web報(bào)表,第三方工具,數(shù)據(jù)源,PSA,BusinessInformationWarehouse,R/3,other,強(qiáng)勁的信息分析-友好的用戶界面-強(qiáng)有力的OLAP分析功能-為各種類型的用戶提供支持-基于角色的權(quán)限管理,豐富的業(yè)務(wù)內(nèi)容大量的信息模型報(bào)表信息對(duì)象數(shù)據(jù)抽取工具,全方位的數(shù)據(jù)倉庫解決方安-能夠集成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ù)的TimeUnitInfopackage,InfoCube,什么是InfoObject?,InfoObject“0COSTCENTER”,InfoObjects就有唯一性，是跨業(yè)務(wù)組件的,Tableofcostcenters,Tableofemployees,各種不同的OLTP數(shù)（業(yè)務(wù)對(duì)象、數(shù)據(jù)字段）在BW中被預(yù)先定義為InfoObject,Dimensiontable,SAPBW:擴(kuò)展的星型結(jié)構(gòu),PCTQuantityRevenueDiscountSalesoverhead250500,000$50,000$280,000$50100,000$7,500$60,000$.,Facttable,事實(shí)表,事實(shí)表中的每一個(gè)記錄都有是通過維度表中的KEY唯一確定的事實(shí)表在上傳業(yè)務(wù)數(shù)據(jù)時(shí)被維護(hù),Timedimension,Productdimension,Customerdimension,維度,維度表的鍵在事實(shí)表中被作為外鍵在維度表中包含主鍵，維度號(hào)碼和特性,CCustomer#Region13970522west.,PCTQuantityRevenueDiscountSalesoverhead250500,000$50,000$280,000$50100,000$7,500$60,000$.,時(shí)間維度,產(chǎn)品維度,TPeriodFiscalyear042000.,PProduct#Productgroup2101004displays.,事實(shí)表,客戶維度,星型結(jié)構(gòu),事實(shí)表和維度表的組合被稱之為星型結(jié)構(gòu)The,TransferRules,數(shù)據(jù)抽取,UpdateRules,InfoCubes,Communicationstructure,TransferStructure,BusinessInformationWarehouseServerStagingEngine,OLTPSourceSystem1,OLTPSourceSystem2,TransferRules,TransferRules,數(shù)據(jù)抽取方式,Communication-structure,Updaterules,Transfer-structure,PSA,IDOC,TRFC,255fields,1026bytes,1000bytes,BAPI,file,Thirdparty,Length250+additionalsegments,APSAforeachTransferstructure,BAPI,R/3connection,Transferrulesapply,TransferRules,Extractionmethodchosenintransferstructure,管理員工作臺(tái),SAPBW對(duì)系統(tǒng)管理的核心組件,監(jiān)控?cái)?shù)據(jù)傳輸,計(jì)劃和運(yùn)行數(shù)據(jù)抽取,數(shù)據(jù)倉庫設(shè)計(jì)，維護(hù)和管理,Admin.Workbench,角色,CommonMetadata,業(yè)務(wù)內(nèi)容,信息立方體,信息源和數(shù)據(jù)抽取接口,查詢,工作簿,業(yè)務(wù)內(nèi)容,使用BExAnalyzer創(chuàng)建查詢,SAPBEx:ChooseQuery,Cancel,Open,Availableobjects,Salesanddistribution,Customer,Creditmemos,Customerincoming.,Purchasing,Purchasingdata,Find,Definition,Newquery,2,1,選擇特性和關(guān)鍵指標(biāo),NewQuery,Filter,User-def.char.,FIARTransactiondata,Keyfigures,Accumulatedbalance,Totalcreditpostings,Totaldebitpostings,Salesvolumeinperiod,Dimensions,Customer,Sector,Customernumber,Country,Companycode,Currencytype,Time,Unit,Rows,Cust.,Ac