Skip to Content
0
Mar 22, 2021 at 05:45 PM

0UC_SALES_SIMU_03 - Data Loading is taking long from ISU to BW4HANA

64 Views Last edit Mar 22, 2021 at 05:51 PM 2 rev

Hi All,

We have implemented Sales Simulation Datasource (0UC_SALES_SIMU_03) recently and performed the full data from ISU to Write-Optimized DSO in BW4HANA for loading the historical data. It took 4 Days 17Hr to complete for appx.311 Million records and for weekly delta loads it is taking 1 Complete Day for loading 78-80 Million records. There are few customization being done at extractor level.

Please note the same Extractor is taking 3 Hour in our old SAP BW7.5 system for weekly loads.

After further analysis I have noticed that the load is taking maximum time in the step highlighted below ( Prepare for Extraction ). It seems HANA is bringing all the records sequentially and then distributing into packages. Also as it is BW4HANA , we don't have control on package size and HANA is assigning the package size on itself.

Hence would like to know what could be the possible steps/improvements that can be done in order to load the data much faster in BW from Source.

Attachments

capture1.png (30.6 kB)
capture1.png (97.1 kB)