Is it possible to obtain native SQL query that is executed over the graphical Calculation View?

[YuriiPlakhtii]

Hello! I'm trying to find out, if it is possible to get SQL query, that will be executed on the DB, when user gets data from the Calculation View?

I know how to obtain XML definition of the Calculation View, but I believe eventually data from the DB is retrieved by running SQL query to the database. Is there a way how to get this SQL query for the Calculation view? Ideally programmatically.

Thanks in advance!

[CharlesFeng]

Hi @YuriiPlakhtii,

I think you can find the SQL statement by enabling SQL trace in the target HANA database.
You can find more detailed steps about enabling SQL trace in KBA 2031647 - How to enable SQL Trace in SAP HANA Studio

Best regards,
Charles