Analysis Services Synchronization fails with permissions error

When you want to run Synchronization to copy an Analysis Services database from one server to another, the account running the synchronization needs to be a server admin in the Analysis Services instance receiving the database.   For example, when running a job to do synchronization from a SQL Agent job, you may see the…

0

SQL 2012 Data Mining Add-in for Office 2013 prerequisites error

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 of Office that are installed.  Error:…

2

Getting Error in an Excel 2010 PivotTable “The field that you are moving cannot be placed in that PivotTable area” when referring to PowerPivot data sources

We kept getting this error when attempt to drag and drop dimensions attributes into a PivotTable in Excel 2010 “The field that you are moving cannot be placed in that PivotTable area” We were trying to use an Excel workbook to drop in dimension attributes that are sourced from data living in the PowerPivot for…

0

Enabling logging to troubleshoot MDSModelDeploy.exe

In the situation where you are trying to deploy an MDS model via the package to your Master Data Services in SQL Server 2012 you can sometimes encounter failures. Sometimes it says “See exception details for more information.” and you want to get more context on the failure. This failure is a pretty trivial one,…

0

Analysis Services Stops Accepting New Connections –Processing commit locks hurt

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…

1

Error from AS client tools – "Property name was not recognized, ‘APP’"

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 but the MSOLAP11 version…

0

Analysis Services Cube processing fails with error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008."

  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 the caller) If you get lucky, you can…

11