Skip to Content

Live Cache performance issue with UoM conversion

Hello, we're experiencing significant drop in performance when updating / saving Time Series KeyFigure values in APO DP.

The problem seems to occur when users are switching to alternative UOM in interactive planning.

For example, when editing data on aggregate level with 850+ corresponding Characteristic Value Combinations(CVC) on the lowest level, saving 12 KF's takes:

15 seconds in Planning Area UOM(Unit of Measure)

795 seconds in Alternative UOM

With persistant aggregates defined, it is having little impact on performance.

From Application server perspective, we're seing that 99% of the time is spent in LC stored procedure SAPTS_SET_DATA (which invokes LCA functionality), but have no further visibility as to what is happenning inside the LCA.

We're looking for any suggestions on how to trace / debug what is going on inside LCA and how performance can be optimized.

More specifically we're trying to understand how LCA obtains product master UOM conversion factors:

1)are these stored in livecache

2)are these being passed to SAPTS_SET_DATA as a parameter (this seems unlikely)

3)is LCA accessing OLTP (/SAPAPO/MARM table) directly

(any links on how stored procedure is processed will also be helpful)

Will surely reward points for helping

Thanks

Srinivas

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 18, 2008 at 10:33 PM

    Hello Srinivas,

    -> You already posted the question at

    Live Cache Performance issue using alternate Unit of Measure

    -> For the reported problem I recommend you to create the OSS message to

    the component 'BC-DB-LCA' or 'SCM-APO-FCS', therefore we could logon to your system via

    OSS and take a look closer on the issue.

    -> What are the versions/builds of the liveCache/LCA<COM> on your system?

    What is SCM<APO> SP?

    In the past some problems are discribed & the hints how to avoid them given in

    the SAP note 528005 - "Interactive planning DP with changed UoM is slow" .

    Please review the SAP Note No. 959610, this note provides changes and corrections for

    the unit of measure conversion in the interactive planning.

    As of SCM 4.1 LCA build 13 improved performance when you write key figure data in alternative

    units of measure < Review SAP Note 974947 - SCM 4.1 LCA Build 13 >. Please review

    "Release-Dependent" information at service.sap.com/liveCache

    Thank you and best regards, Natalia Khlopina

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks very much Natalia for the reply. I raised the issue in two forums since they are viewed by two different sets of people. We were planning to raise OSS based on some ST22 dump notes we were getting.

      Live Cache COM module info APO 4.10: 009-001-345-759 (LCA Make ID 88628, Release 4.1_B9 and Patch 001)

      SCM APO version SAPKY41009

      Oracle DB level 10.2.0.2.0

      Would you mind telling us if the above stack is sub-optimal or something for performance ?

      We will go through the notes you mentioned some of which we had gone through.

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.