Class not registered error after restoring an Analysis Services database that uses the SQL Server 2005 SQL Native Client.

After restoring an Analysis Services database that uses the SQLNCLI.1 SQL Native Client (SNAC) on a server which has never had SQL Server 2005 installed, an error similar to the following occurs during processing operations: Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Class…


Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases…

An Analysis Services 2005 query against a calculation on a cell may report the error:  “The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples.”  This may be because there are simply more underlying cells in the query than the supported maximum, but in some cases, the query can…