Skip to Content
avatar image
Former Member

underlying query of Attribute View in Sap HANA Modeling

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 14, 2017 at 06:03 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded