SAP BW 数据加载计划

PREFACEThisdocumentisintendedforreadersthatarealreadyfamiliarwithBusinessWarehousingmodelsspeciallySAPBW.KnowledgeofSAPBWandR3isrequired.ThedocumentiswrittenwithreferencetoSAPBWbuttheconceptsdiscussedcanbeusedforanydataloadingactivity.Theactualdependenciesmayvaryfromprojecttoproject.TermsUsedinthisDocument:DataLoad:Adataloadmeanstheactivityofextractinginformationfromadatasource(e.g.atable)andstoringitinadatatarget.DataSource:AdatasourcecanbeatableoraviewinR3systemoranODS/InfoCubeinBWsystemDataTarget:AnODSoranInfoCubeinaBWsystem.Request:Adataloadrequestthatrepresentsadataload.PlanningPhase........................................................................................................................................................3FactorsInfluencingdataload:..........................................................................................................................4TablesContainingDatatobeloaded:............................................................................................................4EstimatingNumberofRecordstobeextracted:...........................................................................................4EstimatingLoadingSpeeds:.............................................................................................................................5CollectingNumberofrecordsperminuteinformation:.............................................................................5EstimatingResourcesAvailableforloadingdata:.......................................................................................9ManagingSpace....................................................................................................................................................11Step1:Estimatingthesizeofwarehouse....................................................................................................11Step2:ManagingTableSpaces......................................................................................................................13LoadingPhase.......................................................................................................................................................14RunningaLoad:................................................................................................................................................14ManagingFreeSpace.......................................................................................................................................15ManagingDataLoadPerformance................................................................................................................15ManagingNumberofProcesses....................................................................................................................16ManagingMemoryandCPUprocessingcapability..................................................................................17HistoricalDataLoading:.....................................................................................................................................17LoadinghighVolumeofData........................................................................................................................18LoadingFinancedata:.................................................................................................................................19WareHouseManagementDataLoading:................................................................................................20UsingOff-ShoreResources............................................................................................................................21Step1:CreatingHandoffdocuments.........................................................................................................22Step2:ExecutingDataLoadPlan:..............................................................................................................23Step3:QualityAssurance:...........................................................................................................................23DataLoadingDataloadingisanongoingprocessforanydatabase.AscomparedtoatransactionprocessingsysteminabusinesswarehousethatisanAnalyticalProcessingSystemdataisloadedinbulkmostofthetime.Businesswarehouseshouldbetunedproperlytoexpeditethedataloadingprocess.DatamigrationisaveryimportantphaseofallBWprojects.Itisusuallydifficulttoanalyzethedatatobeloadedandestimatethetotalloadtimesforeachindividualtarget(ODS/InfoCube/MasterDatatargetetc.)Inlargebusinesswarehouseprojectitisimperativetoestimatethesetimesaccuratelyotherwisetheycanhaveseverimpactontheprojecttimelines.Throughproperplanningnotonlywecangetgoodestimatesfortheloadtimesbutwecanalsoconfigurethewarehouseforbestperformance.Wecandividethedatamigrationprocessintotwophases:1-PlanningPhase2-LoadingPhasePlanningphaseisusuallymoredifficultdependingonthesizeanddiversityofdata.Insomecasesitisdifficulttoaccuratelyestimatethesizeofthedatathatwillbeloadedtothebusinesswarehouseandtheamountoftim