Hello,
MDX query errors can happen for a variety of reasons including some required HANA tables not being available. There are many notes available for HANA related issues. My recommendations is to focus one the ones that will help you get the MDX or SQL query that is failing to execut.
If you can capture either the SQL or the runtime MDX query you can then execute them directly and get more detailed error.
To get the runtime MDX use either SLG1 or UJSTAT. Please follow the instructions in note 2086208 and execute the query to get a more detailed error.
You can also capture the SQL query and then execute the query directly on HANA server. You can get the query by enabling the HANA trace using DBCOKPIT or DB02. Please follow the instructions in notes 1998549 or 2119087.
The query will also show in the system log, using SM21 check system errors. To get the runtime MDX use either SLG1 or UJSTAT. Please follow the instructions in note 2086208 and execute the query to get a more detailed error.
After you have the query that is causing the error you can execute it directly on HANA studio. That will show you more specific HANA related errors. I hope this helps.
Best Regard
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.