Issue: MDX Query not executing in Hana Studio 2.0.8 Version

[Former Member]

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.

[shady_shen · Accepted solution]

You can try,

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

[Former Member · Accepted solution]

Thanks Shady,

The steps you suggested helped me to get the issue resolved.

Now I am able to run the MDX query in Hana Studio.

[lbreddemann]

Well, searching for the error message would have helped here.

As I explained in Regarding "Generate Time Data" Option in HANA | SCN

...apparently there had been a change in the SAP HANA studio so that now all SQL commands get prepared before execution...

Anyhow, I was able to do something like this on rev. 96:

create procedure run_upd_time ()
language sqlscript
as
begin
    exec 'MDX UPDATE TIME DIMENSION Year 1950 1953';
end;

call run_upd_time();
...

In other words: you need a wrapper (and some more exercise with search engines... )