Register Login

BI Load with Respect to a DTP Runs for a Long Time.

Updated May 19, 2018

Hello Experts,

Quite often BI consultants complaint the Basis team that there BI load with respect to a DTP runs for a long time.

For every datapackage extracted it takes 20 mins and there are around 27 to 28 therefore it takes hell lot of time.

Any suggestion where Basis can reduce the time for the load to complete.

Thanks in advance.


Comments

  • 21 Jul 2015 2:53 pm Romil Tripathi Helpful Answer

    Most of the times the answer for this kind of problems in BW is BW team should make changes in how they run laod , they have so many selection criteria available for executing a better load, ask them to fine tune their load. splitting the load is most optimal solution. from BASIS side you can check the logs in case if you have any deficiency in memory or other resources.

    you can also put a trace on that job if its running for a long time very frequently. you can achive it throught /SDF/MON in se38 and monitor it background.


×