Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 14, 2015 at 12:36 AM

    You can try,

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Aug 13, 2015 at 06:03 PM

    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... )

    Add comment
    10|10000 characters needed characters exceeded