Live Cache performance issue with UoM conversion

[srinivas_krishnamoorthy]

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

[former_member229109 · Accepted solution]

Hello Srinivas,

-> You already posted the question at

-> 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

[srinivas_krishnamoorthy · Accepted solution]

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.