on 11-13-2020 4:08 AM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Is there any way to "drill-down" the results? I would appreciate if you could share your experience.
Regards,
Mio
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.