SSAS 2008 Cube Process OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

SSAS 2008 Don’t be confused when ever you face this clueless error while processing your cubes in SSAS 2008. I spent hours searching the internet and found no appropriate answer to over come this problem…. until I scroll my huge list of processing errors and found a ‘warningthat my dimension does not have the Date_SK that is being processed in my fact.

I simply incremental update my time dimension and here it goes. This error is a really fuss for the Olap developers as its clueless and on the internet we have a lot of stories and myths on this issue.

Well this is no myth for me, it worked for me.

Einfobuzz Site Map