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

Hi experts

Hi every one,

How can i improve performance of DTP?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 21, 2012 at 11:36 AM

    Hi

    Loading performance while the data gets loaded from PSA to Datatargets:

    What to check during this data load?


    --> Routines Performance ( Start routine, Field Routines, End Routines, Expert Routines)

    Many a times we have a requirement of doing DSO lookup in the routines. While doing lookup we use select statements. In the where clauses of these select statements sometimes we refer to a data field of the DSO. If this is the case make secondary indexes on those fields of DSO which are being used in LOOK UP.

    Wherever possible make use of formulas instead of Routines.

    What to check for Master Data IOs?

    a) Buffering Number Ranges

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a6e3ff-f000-2d10-b59d-8ef35e248f83%3FQuickLink%3Dindex%26overridelayout%3Dtrue&sa=U&ei=mYwKUMSbCI_NrQe1qOjJCA&ved=0CBEQFjAA&usg=AFQjCNEEAsPT4VCHhBTEfebOoOmKYJCihg

    What to check for Info Cubes?

    a) Indices : Delete the indecies before loading the data.

    b) Roll-Up : Try to build aggregates that are not affected by change run

    c) Loading of Master Data before Transaction data :Master data loads generate SIDs. So while loading transactional data SIDs will not be generated again and hence your loading performance will be improved.

    d) Buffering Number Ranges

    What to check for DSOs?


    a) Parallel DSO Activation :You can make the DSO activation in parallel mode by using this option

    b) Unique Data Records : If you are sure that all your records are unique. The "Unique"-Flag accelerates data activation significantly. Only usable for documents that cannot be changed

    c) Indices on DSO: Do not create un-necessary secondary indices on DSO. Create only when you are doing a look up on this DSO based on data fields

    d) SID generation upon activation :

    This checkbox is by default selected when you create a DSO. This means that while activating the data in a DSO, it will generate the SIDs.

    This can lead to DSO activation performance issues, because the maximum time of activation goes in generating the SIDs of the respective master data.

    If you are not reporting on the DSO, the activation of SIDs is not required

    ------------------------------------------------------------------------------------------------------------------------------------

    And also

    a) Packet size of a DTP:

    Number specified here has a direct impact on memory consumption during extraction.

    If the data is read in semantic groups, all the data records for a particular key have to be contained within the same package. For this reason, a package contains more data records than specified here

    b) If the volume of the data is huge then you can create more number of DTPs and can perform selective loading at DTP level as well.

    Regards

    KRPK.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2012 at 11:02 AM

    Hi siresh,

    Is the provided info sufficient? Are you looking for any specific options?

    Regards

    KRPK

    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.