Skip to Content
0
Former Member
Aug 12, 2015 at 11:35 AM

Issue: MDX Query not executing in Hana Studio 2.0.8 Version

481 Views

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.