Skip to Content
avatar image
Former Member

SDP94: Performance Tuning Benchmarks

Dear APO Admin/DP Experts,

I have a generic question related to loading and drill down time in interactive demand planning in SCM7.0

I do appreciate there are several parameters responsible for the response time, I wish to know from your personal experience, what is the possible response time for the actions below.


Key Figures in Data view: 12

Characteristics in Planning book: 8

CVC's: 100K, with product being one of the char

Storage buckets: 48 months

Time buckets: 36 past months and 12 future months.

Brand new SCM7.0, Ehp1

Sufficient hardware

Sufficient work processes.

Sufficient licenses.

5 users are logged in SDP94

Action1: I load shuffler with all Products .1000 products.

What should be the ideal response time for loading these products to the grid

Action2: I now drill down product in the header.. multiple.. all 1000

What should be the ideal response time ?

You can give any other example. I wish to know is there something wrong with our environment or everyone has had complaints wrt response time esp. in Production environment. In Action 2, I note a response time of 28 minutes. This is pathetic and impractical. I had to increase the dialog response time to do actually complete this.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 18, 2012 at 11:26 AM


    to my knowledge, Action2 is impractical in APO (in the same way than one avoids checking visually 1000 rows in an Excel sheet plus the performance issue). How does a user navigate through 1000 products in the same screen? In this case, one either:

    1) breaks down the products in families and check by family (if you select 100 products and then drill-down, it should be much faster)

    2) use DB alerts to check only the interesting products via /SAPAPO/AMON1 (plan by exception). Examples: forecasting error, anomalies (negative forecast...), this kind of stuff.

    Even in a background job your drill-down action would consume a lot o ftime. If you really need to drill-down all your products simultaneously, you may try to save some time by hiding key figures you won't be using, hiding graphics or creating an aggregate in your MPOS at the product level (, check OSS 503363), so liveCache will read directly the product-level numbers instead of aggregating through the whole database.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks James for providing some reassuring numbers. I was only keen on order of magnitude response times as I have not been a part of any other productive DP before.

      Thanks DB49 for providing some clues. The reason I provided asssumptions above was to limit further assumptions. Surely performance can differ from system to system. My customer cant afford another tuning consultant at this moment so I will make do with what most "functional" consultants do best...offer some lip service and contain the design.. limited key figures per view, only required initialization of storage buckets, parallelize jobs and process chains and such.. which is all in place.

      Yes by now, with whatever few screens I dwelled on, I did realize DP is not Excel but Excel can be a superior and efficient DP tool if used well.

      Thanks for your responses. I am sinking it all in