Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Some dimensions not processing

Status
Not open for further replies.

ianclarke

Programmer
Apr 20, 2005
20
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top