data warehouse sap bex bex dso

《data warehouse sap bex bex dso》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、SAP-BWBusinessDataWarehousing-DataSourceObjectsArchitectureTypesConfigurationSettingOptionsActivationandDesignApplicationScenariosVersion1Module1DataStoreObjects-Definition•ADataStoreobjectstoresReporting&AnalysisLayerconsolidatedandcleanseddatafromtransactio

2、nalsystemsataDataStoreInfocubesdetaillevel.Object“datatargets”TransformationLayer(Persistent)StagingAreaExtractionLayer:InfoPackagePage2Version1Module1DataStoreObjects–Definition(continued)•DataStoreobjectalsotracksReporting&AnalysisLayerchangestodatastoredin

3、transparentflatdatabaseDataStoreInfocubestables.Object“datatargets”•DataStoreObjectsstoreTransformationLayerdatarecordsfrombusinesstransactionslikebilling(Persistent)StagingAreaorsalesdocuments.ExtractionLayer:InfoPackagePage3Version1Module1FUNCTIONSOFDSO•Rep

4、licationofbusinesscriticaldatafromthetransactionalsourcesystemintothedatawarehouse.•Providesflexibilitywhichhelpsinredesignofdatatargets(InfoCubes).•EnsuresconsistencybytransmittingonlyrelevantrecordsorchangesintherecordtodatatargetsabovetheDSO.•Canbeviewedas

5、aDatastaginglayerwheredatavalidation,cleansingandsynchronizationcanbemanaged.Page4Version1Module1DSOversusInfoCubeDataStoreObject(DSO)InfoCubeAnODS/DSOwillhavegranularStoressummarizeddata.leveldetaileddata.OverwritepropertiesexistherebasedDatastoredincubeswil

6、lbeavailableonkeyfieldsthatwedefine.inatanaggregatedlevelforreporting.UtilizesaflatfilestructureresultingComposedofmultipletablesinsimplemodelingoftheDSO.arrangedinaSTARSCHEMAjoinedThereisnoconceptofastarschema.bySIDs(extended).Thestarschemaprovidesmulti-dime

7、nsionalreporting.DirectreportingwillbeslowasthereMulti-dimensionalreportingisfastisalargeamountofgranulardata.andseamless.Page5Version1Module1DataStoreObjects-Features•Replicationofdatawithacombinationofkeyfieldvaluesfromatransactionalsystem.•Providesoverwrit

8、ecapabilitythatcanbeusedtocumulatedataforadefinedkey.•ADSOmayalsofunctionasanInfoProvider.•QueriescanbecreatedontheDSOsimilartothoseonanInfoCube.•Report-to-Reportinterface(RRI)canbeusedto