Skip to Content

How to analyze performance of Analytical Query?

Hi experts,

I want to analyze performance of an Analytical Query (the one used in Query Browser app).

I tried to take a trace with ST05 and ST12, but I couldn't see the target CDS view in the result list.

I executed the query from Query Browser as well as tr: RSRT, but in nether case access to the CDS view was not recorded.

If I execute a list report app on top of (not analytical) CDS view, I can see the CDS view in the trace result list.

Maybe ST05 is not the right tool for Analytical Query, because they are processed by Analytical Engine?

Then, how can I analyze performance of Analytical Query?

9kylg.png (50.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 13, 2020 at 05:52 AM

    Hi Mio,

    Upon the SAP Note 1707239, just a supplement to your result on ST05 - when the Analytical Query is called from analytical engine(in this case Query Browser), SELECT statement runs on its source CUBE view - which is Interface view of the Analytical Query.

    For example, when you see "C_MaterialStockActual" from Query Browser (or let's say Design Studio) and trace it with ST05 , you can see SELECT statement is running on "IMATERIALSTOCK" which is a SQL View of I_MaterialStock.

    I_MaterialStock is a source CDS View of "C_MaterialStockActual", annotated with @Analytics.dataCategory:#CUBE.

    So if you want to trace Analytical Query with ST05,

    1) Check its source CDS View (CUBE view)

    2) Check the name of SQL View of the CUBE view

    3) In ST05, the name of SQL View will be on the SELECT statement

    Best regards, Yuto

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 13, 2020 at 04:39 AM

    Hi Mio.

    Refer to this SAP note link https://launchpad.support.sap.com/#/notes/1707239

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Siram,

      Thank you for the information. I executed the query with statistics.

      Now, the "Aggregation Layer" tab shows access time to a single cube. If I were to identify performance bottlenecks, I would need more detailed information such as which view access took how much time.

      result.png

      Is there any way to "drill-down" the results? I would appreciate if you could share your experience.

      Regards,

      Mio

      result.png (63.1 kB)

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.