If you try to install the Data Mining Add-in into Office 2013 the setup may fail with the prerequisite error. This may happen if you are using the ClickToRun install of Office, chances are you still have Office 2010 or another version side-by-side, as ClickToRun  doesn’t uninstall previous versions...

This common blocking symptom really can cause trouble if you get caught off guard. When you process an Analysis Services object, like FullProcess on a database or cube, near the end of processing is the phase where it needs to swap the old files out and replace it with the new files a lock is needed...

Every time I try to connect to my SQL Server 2012 Analysis Services, from Management Studio or SQL Profiler I kept getting this error popup and I cannot connect. "Property name was not recognized, 'APP'"   I figured it out… I ran process monitor and found that MSOLAP8 had been registered...

Lots of similar errors during processing Analysis Services processing (on Adventureworks DW cube in my example) can fail with this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008 ." In SQL OLEDB terms HY008 means DB_E_CANCELED (aka your query was cancelled purposefully by...

  To make a new dimension or any object in an SQL Server 2008 Analysis Services database, the user must be in a role that has “Full control ( Administrator)” permissions. I confirmed this by breaking my role, getting an error, and researching the source code which throws the error to see what conditions...

Today we got a fun one… In Visual Studio Team Foundation Server 2010, the server has a SQL Server database(s), an SQL Server Analysis Services database (cube), and several reports on top of the cube. There were two symptoms: 1. Data was not refreshed when using the Reports in VSTFS Admin...