View the execution plan of SAC widgets/ charts

[ThanhHieuNguyen]

Hello experts,
   I currently using SAC with a Live Connection to my SAP HANA database. When I create a Chart in SAC to view my data, sometimes I get the error "Fail to fetch data" (It has occurred randomly, not all the times) <See the image attached below>.
   The chart is about getting the Top 5 Best Sales Products by Quantity. The data source has about 2 million rows of data, and the Chart also uses the filter to remove the unnecessary products. I wonder whether the errors occurred because my server did not meet the resource requirement to query the data or because it was a SAC issue. So I want to view the execution plan, and query of each Chart/ Widget to run that query under my HANA server. Is there any solution? ( I found that SAC only has the Analyze Story Performance in View Time option to track the time of each Widget, but does not have the execution plan).
I appreciate your help.
Best regards,

Nguyen Thanh Hieu

 

[Yogeshwar_M]

Hi check this:,

1.Filters or dimensions in the query might not align with the available data.
Dynamic input variables may not have valid values.

2.Ensure the query is valid and aligns with the model's data structure.

Remove filters temporarily to test data retrieval.

3.Try to comment out unnecessary scripting part.