cancel
Showing results for 
Search instead for 
Did you mean: 

OLAP Other Time (3999) and PE: Aggregate (51099) very high times at RSRT - Plan Query

regysm21
Active Participant
0 Kudos

Hi Experts,

we are performing some query performance analysis and we have some planning queries that we are doing the analysis on them. Unfortunately we have identified two OLAP Processes that take infitely time to end up:

  • OLAP Other Time (3999) - This takes for our planning query normally 500-600 Seconds
  • PE: Aggregate (51099) - This takes for our planning query normally 350-450 Seconds.


I tried to find some explanation for the Both OLAP Processes above, but seems not to be a lot of information around about. Could anyone give some suggestion please why it could be like this? Or with what performance issue/improvement can we relate these two OLAP Processes?

Thanks,

Regys

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi Regys,

statistics can give you only some overview. One approach to get more information is to record an RSTT trace (note 899572) of your planning scenario. It is possible to replay the trace in RSTT; you can get some information about run time there. You can also use transaction SAT to do a run time analysis of the recorded RSTT trace. There one can see the hot spots on the code level.

Unassigned time might be high if you have some time consuming checks in planning (data slices, characteristic relationships, complex data model (compound characteristics)). Event PE: Aggregate (51099) indicates that data has to be read from HANA to the ABAP level; this might be needed if no HANA implementation is available for some features (fields in aDSOs, characteristic relationships, data slice using the ABAP fallback, cf. note 1956085).

Usage of HANA views in planning models (characteristics based on HANA views, InfoProvider based on HANA views) might also lead to bad performance, e.g. if single records are read very often; cf. notes for 2708611, 2707223 for recent improvements.

Note 1694205 contains information about PAK (Planning Applications Kit) problem analysis in general.

Regards,

Gregor

regysm21
Active Participant
0 Kudos

Hi Gregor,

thank you so much for the detailed response. I will check the points mentioned by you and hope to find more information about them.


Best regards,

Regys

Answers (1)

Answers (1)

Hi,

note 2291095 contains some information about statistic events in planning.

Regards,

Gregor

regysm21
Active Participant
0 Kudos

Hi Gregor,

thanks a lot for the SAP Note. 🙂 It has some useful information that will me further with my analysis, however do you know if there is any other SAP Note that can explain the process 51099: PE Aggregate (In the SAP Note that you provided is only descirbed as a Process without detailed information on what this process consist of.). It mentions the Table: RSR_PE_LOG, however in my system this Table is empty. Do we have to activate something so that this table get filled with information about the Process: 51099:PE Aggregate?


Also is it normal for Planning Queries that the Process: OLAP Other Time (3999) this much times consumes? If not, then could you please provide me a hint on what it can rely? In the SAP Help description, it simply says for this process: "Runtimes in the analytic manager (OLAP) that are not specified in more detail." Source: https://help.sap.com/viewer/dd104a87ab9249968e6279e61378ff66/11.0.3/en-US/45f0488a1aa03115e10000000a...

Thanks a lot!

Regys