![]() ![]() Cube indexes - For better performance, Cube indexes should be dropped each time before loading the data to the Infocube and rebuilt post the data load to the cube.There are mainly be 2 reasons of longer data load time to the Infocube : Loading Data to Infocube - It is many a times observed that loading data to Infocube takes a longer time as seen in the below figure: ![]() Following papers may be referred for better insight: Each routine has its own purpose and based on the scenario the decision of right fit routine should be made.ĭiscussion on ABAP performance optimization and Decision on Transformation Routines is not in the scope of this paper. In order to enhance the performance of the DTP, the ABAP code written in the Transformation should be optimized. However, most of the times these routines become necessary for implementation of the required Business logic. The use of Start Routine, Characteristics or Field level routine, End Routine OR an Expert routine affects the performance of DTP at each level. Transformation basically includes the processing of Data via ABAP Routines, Formulas, Masterdata read. The following figures depicts the scenario where time taken in extraction can be considerably reduced by regular deletion of PSA requests. In order to improve the performance of Extraction, PSA and Change log requests should be periodically deleted and retained for the minimum required time period. Extraction takes longer time to complete while the Data contained in the source Data object is huge. PSA, DSO's change log, Info Cube, Master Data Info Object. Huge Data contained in PSA / DSO change log - While we execute a DTP in Delta mode, it extracts Delta requests from one of the following persistent Data objects: Let's take a look at probable reasons and their solutions: There could be multiple reasons for longer time during extraction. You would observe the time taken for Extraction may vary from few seconds to even hours in few cases. Typically the first package of a DTP takes the highest amount of time for extraction. Data in DTP is extracted and processed in packages. The time taken by the DTP to complete Extraction mainly depends on the amount of Data available in the source object. Extraction is the process of extracting Data from a persistent Data object. The 'Details' tab in the DTP monitor, details the progress of a DTP with corresponding Time-stamps at each step.Ī DTP transfers data between two persistent/non persistent objects within BI. Performance of a DTP can be analyzed in the DTP monitor screen. Performance of a DTP can be analyzed primarily in 3 steps. It is DTP that determines the further loading of data thereafter.įor further details on DTP, its benefits, functionality and use, refer Document: All about Data Transfer Process (DTP) - SAP BW 7 Data Transfer Process (DTP) - Analysis and Performance OptimizationĭTP determines the process for transfer of data between two persistent/non persistent objects within BI.Īs of SAP NetWeaver 7.0 and above, InfoPackage loads data from a Source System only up to PSA. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |