Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Capture MDX Statement from HANA Studio

|| 1

Capture MDX Statement from HANA Studio
Stechies

How to capture MDX statement from HANA studio?

Hello SAP Experts,

I want to know the exact MDX statement which is generated from the application side (e.g Microsoft Excel) and executed in HANA server.

Thanks in Advance


Comments

  • 29 May 2018 6:32 pm Best Answer

    In order to capture MDX statement from HANA Studio you need to follow the steps given below:

    1) You have to turn on MDX trace as debug mode

    In order to turn on MDX trace as debug mode open SQL console in HANA studio and run the following command:

    • alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','mdx')='debug' with reconfigure;

    2. Now the second step is to generate or refresh the report

    3. Now please Open an indexserver trace, and find keyword "MDX Statement"

    •     You will find the MDX statement after the keyword.

    4. At last turn off MDX trace using following command

    • alter system alter configuration ('indexserver.ini','SYSTEM') unset ('trace','mdx') with reconfigure;

Advertisement
Advertisement
Advertisement