underlying query of Attribute View in Sap HANA Modeling

[Former Member]

Hi,

I have an attribute view with output columns and calculated columns using sap hana modeling.

Its working fine and i am able to see the data.

I just want to make use of the underlying sql query which is executed while this attribute is querying the data.

Because internally every thing will be executed as query to the query engine.

Please suggest me a way to get the query which is executed while attribute view is called.

[Former Member]

Hi,

In order to get the sql query of any view from SAP HANA Studio (for Any version of SAP HANA), during the Data preview of the view, there will be an option like "show logs".

Click on the Show Log option, you will get a dialog box like "Data Explorer Log" in that you will have a column like "Message".

In the Message column, you will see the entry like "generate sql". On double click, you will able to see the Sql query used for the respective view.

I have attached the screenshots for reference.

show-logs.pngshow-log2.png

Thank you.

Best Regards,

Sajeed.