Hi All
I'm building a new cube. When processing some dimensions will process successfully, but others won't. All dimensions are in the same database, so security should be the same. If I take the queries and run them in management studio I get results without any problems.
In the Process Progress window of the dimensions that error, some attributes complete successfully, but where they don't they get the same following errors:
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of '<dimension name>', Name of '<dimension name>' was being processed.
Errors in the OLAP storage engine: An error occurred while the '<attribute name>' attribute of the '<dimension name>' dimension from the '<db name>' database was being processed.
I've been looking at this all day - any help would be much appreciated.
Thanks a million
Ian
I'm building a new cube. When processing some dimensions will process successfully, but others won't. All dimensions are in the same database, so security should be the same. If I take the queries and run them in management studio I get results without any problems.
In the Process Progress window of the dimensions that error, some attributes complete successfully, but where they don't they get the same following errors:
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of '<dimension name>', Name of '<dimension name>' was being processed.
Errors in the OLAP storage engine: An error occurred while the '<attribute name>' attribute of the '<dimension name>' dimension from the '<db name>' database was being processed.
I've been looking at this all day - any help would be much appreciated.
Thanks a million
Ian