Skip to Content
0
Former Member
Nov 02, 2012 at 02:50 PM

Executing MDX from the studio

269 Views

Hello all,

I am currently trying to execute MDX queries on a Analytical view in the HANA Studio. The query is very simple:

MDX SELECT

{ [Origin].Members } ON ROWS,

{ [Time].Members } ON COLUMNS

FROM [package_name/ANALYTICS]

WHERE [Measures].[Visits]

After trying different variations of this query I get these messages:

Could not execute 'MDX SELECT { [Origin].Members } ON ROWS, { [Time].Members } ON COLUMNS FROM ...'

SAP DBTech JDBC: [256]: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube package_name/ANALYTICS could not be found. Please check if the Cube is valid and exists. The detail error message: Entity cache: cache failed to load correctly: cube package_name/ANALYTICS could not be found in "_SYS_BI"."BIMC_CUBES"

Could not execute 'MDX SELECT { [Origin].Members } ON ROWS, { [Time].Members } ON COLUMNS FROM [ANALYTICS] WHERE ...'

SAP DBTech JDBC: [256]: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube ANALYTICS could not be found. Please check if the Cube is valid and exists. The detail error message: Error on thread for hierarchyID 53

Could not execute 'MDX SELECT { [Origin].Members } ON ROWS, { [Time].Members } ON COLUMNS FROM ...'

SAP DBTech JDBC: [256]: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube ANALYTICS could not be found. Please check if the Cube is valid and exists. The detail error message: Error on thread for hierarchyID 53

Could not execute 'MDX SELECT { [Origin].Members } ON ROWS, { [Time].Members } ON COLUMNS FROM ...'

SAP DBTech JDBC: [256]: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube package_name/ANALYTICS could not be found. Please check if the Cube is valid and exists. The detail error message: Entity cache: cache failed to load correctly: cube package_name/ANALYTICS could not be found in "_SYS_BI"."BIMC_CUBES"

Thanks for your help,

Nicolas.