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.