Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue: MDX Query not executing in Hana Studio 2.0.8 Version

Hi Guys,

I am trying to run MDX query in Hana Studio Console but its not running.  The version of Hana Studio is 2.0.8

Query is:-

MDX

SELECT

{ [PARENT].members } ON COLUMNS

FROM [AN_TEST]

CELL PROPERTIES VALUE

Error Report Coming is:

Could not execute 'MDX SELECT { [PARENT].members } ON COLUMNS FROM [AN_TEST] CELL PROPERTIES VALUE'

SAP DBTech JDBC: [2]: general error: MDX query doesn't support prepared statement.

I have tried lots of other ways but every time I am getting this same message.

The same query is running fine in Hana Studio 1.8 with my credentials.

The Hana server is SP09 for both the version of Hana Studio.

Kindly suggest some way to come out of this problem.

Tags:
replied

You can try,

window > preferences > SAP HANA > Runtime > SQL --> deselect "Prepare statements before execution"

4 View this answer in context
Not what you were looking for? View more on this topic or Ask a question