cancel
Showing results for 
Search instead for 
Did you mean: 

How to analyze performance of Analytical Query?

MioYasuatke
Active Contributor
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

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

MioYasuatke
Active Contributor

Hi Yuto,

Thank you for your reply. I was able to extract SELECT stetement on the Cube.

This enabled me to analyze the executed plan on PlanViz.

Regards,

Mio

Answers (1)

Answers (1)

Sriram2009
Active Contributor

Hi Mio.

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

Regards

SS

MioYasuatke
Active Contributor
0 Kudos

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