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

How to increase the performance of a multiprovider?

1.performaance for ods

2. while loading data in a cube, how to increase performance

Please search the forum before posting a thread

Edited by: Pravender on Feb 4, 2012 10:59 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 06:25 PM

    Hi,

    Before loading data delete the index of the cube and after successful data load recreate it again.

    Regularly delete the changelog table of DSO.

    Edited by: Pradeepkdas on Feb 3, 2012 7:26 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 03, 2012 at 06:35 PM

    hi,

    check the setting maintained for the data transfer , also check for following under setting "SID generation ",

    also try Delete the Cube indexes while loading data to cube and then re built it, also try to optimize start /end routine codes.

    you can Increase the number of parallel processing for that DTP and also try chaging Data packet size in the DTP(in tcode RSCUSTV6)

    also if data loaded to infocube is in huge amount then you can try implement number range buffering as well

    hope it helps

    regards

    laksh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 07:11 PM

    Hi

    Please give the title relevant to post, so that you will get more replies.

    DSO loading improvements:

    1) do not use semantic groups in DTP unless it is required.

    2) use serial extraction and immediate parallel processing in DTP execution tab.

    3) periodically delete the change log table of DSO.

    Info Cube:

    1) delete index before loading and create it after loading is done.

    2) first two points of DSO performance is applicable here

    3) Compress the data based on business requirement(once in 15days or once in a month)

    Regards,

    Venkatesh

    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.