Skip to Content
0

underlying query of Attribute View in Sap HANA Modeling

Apr 07, 2017 at 06:47 AM

71

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sajeed Khan
Apr 14, 2017 at 06:03 AM
0

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.


show-logs.png (50.9 kB)
show-log2.png (29.5 kB)
Share
10 |10000 characters needed characters left characters exceeded