Record Mode Concept in Delta Management

SAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG1RecordModeConceptinDeltaManagementAppliesto:SAPBI2004sorSAPBI7.x.Formoreinformation,visittheBusinessIntelligencehomepage.SummaryThisdocumentexplainstherecordmodeconceptwhichdescribeshowchangestodatarecordsarerecordedduringdeltaprocessing.Author:ApekshaManiarCompany:L&TInfotechCreatedon:04January2010AuthorBio:ApekshaManiar,workinginL&TInfotechhasanexperienceofmorethan3yearsinSAPBI.ShehasbeenapartofProductionSupport,DevelopmentandImplementationProjects.RecordModeConceptinDeltaManagementSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG2TableofContentsWhatisDelta?....................................................................................................................................................30recordmode.......................................................................................................................................................3Thevaluesfor0recordmode...........................................................................................................................3HowdoweidentifytheDelta?............................................................................................................................4HowDataisBroughttoBI..................................................................................................................................5ABR:AfterBeforeandReverseImage...........................................................................................................5ExampleofABRDeltaProcess...................................................................................................................................5AIE/AIM:AfterImageDeltaProcess...............................................................................................................6ExampleofAIE/AIMDeltaProcess..............................................................................................................................6ADD:AdditiveDeltaProcess..........................................................................................................................7ExampleofADDDeltaProcess...................................................................................................................................7RelatedContent..................................................................................................................................................7DisclaimerandLiabilityNotice............................................................................................................................8RecordModeConceptinDeltaManagementSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG3WhatisDelta?Deltaisafeatureoftheextractor,whichreferstothechanges(new/modifiedentries),occurredintheSourceSystem.0recordmodeTherecordmodedescribesthetypeofchangethatadatarecordcontains.Ifadatasourceisdeltacapable,thefieldROCANCELwhichispartofthedatasource,holdsthechangesfromR/3side.ThisfieldfortheDataSourceisassignedtotheInfoObject0RECORDMODEintheBIsystem.ROCANCELservesthesamepurposeatR/3sidewhichitscounterpart0RECORDMODEdoesatBWside.Thevaluesfor0recordmodeFigure1Thefollowing6RecordModetypesareavailable,whichidentifyhowadeltarecordisupdatedtothedatatarget:After-image‘‘:Therecordprovidesanafterimage,i.e.howdoestherecordlooklikeafterthechange.Thestatusoftherecordafterithasbeenchanged,orafterdatahasbeenaddedistransferred.Before-image‘X’:Therecordprovidesabeforeimage,i.e.whatdidtherecordlooklikebeforethechange.Thestatusoftherecordbeforethechangeistransferred.Add‘A’:Therecordprovidesanadditiveimage.Onlythedifferencesforallthenumericvaluesareavailable.Delete‘D’:Thisrecordmodetypesignifiesthattherecordmustbedeleted.NewImage‘N’:Therecordprovidesanewimage,i.e.whenanewrecordiscreated;anewimageissetforit.ReverseImage‘R’:Therecordprovidesareverseimage.Thecontentofthisrecordisequivalenttoabeforeimage.TheonlydifferenceoccurswhenupdatingaDataStoreobject:Anexistingrecordwiththesamekeyisdeleted.RecordModeConceptinDeltaManagementSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG4HowdoweidentifytheDelta?Thedeltaprocess(howthedataistransferred)fortheDataSourceisdeterminedinthetableROOSOURCE(inthesourcesystem)orinthetableRSOLTPSOURCE(inBIforDataSources3.x)orinthetableRSDS(inBIforDataSources)respectivelyPropertiesofthedeltaprocessaredeterminedinthetableRODELTAM(inBIorinthesourcesystem)Figure2RecordModeConceptinDeltaManagementSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG5HowDataisBroughttoBIDataisbrought(extracted)toBIusingoneofthefollowingdeltaprocesses:ABR:AfterbeforeandReverseimageAIE/AIM:AfterimageADD:AdditiveimageABR:AfterBeforeandReverseImageWhatisit?OnceanewentryispostedoranexistingpostingischangedatR/3side,anafterimageshowsthestatusafterthechange,abeforeimageshowsthestatusbeforethechangewit