Skip to Content
author's profile photo Former Member
Former Member

how to improove data Load runtime of infocube which takes more time(10mins)

Hi All,

I am trying to load data from PSA to Info cube where in transfer rules we have 6 formulas which are used to convert chars to upper case.now iremoved these formulas and wrote the same formulas in update rules to check whether it improve the performance of data load runtime.

please let me know how to improve data load runtime.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Sep 13, 2011 at 08:16 PM

    It should improve the data. Here is the article related to his;

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c0e85db9-b0ba-2e10-459b-e4428af08196

    other things which you can check to improve load performance in cube is;

    • delete index before data load and create the indexes again after the load

    • parallel process - you can increased hte parallel process in for a data load in case you are using DTP.

    Regards,

    Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 03:32 AM

    Hi,

    Please check these two links for improving data load performance.

    http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/3a699d90-0201-0010-bc99-d5c0e3a2c87b

    http://wiki.sdn.sap.com/wiki/display/NWTech/DataLoadPerformance+Optimization

    Thanks,

    Indrashis

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 03:48 AM

    Hi,

    I read somewhere that usage of routine instead of formula improves the performance, even I found one thread also.

    [Transformation formula vs. routine;

    Check if you can try something on the same lines.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2011 at 04:19 AM

    Hi,

    If data is already available in DSO and PSA once pl skip PSA load to Infocube ,directly load to data target Infocube.

    It will improve the speed to a greater extent.

    Thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.