-
Analysis services -> Clear Cache
Just a short note about analysis services and its cache 🙂 One of the reasons for analysis services fast respond time is its cahce. But what if you want to test a query without using the cache? Well, just use this XMLA Script: Also, if you do partial processing, the cache, can in some cases… Continue reading
-
Why I don’t think powerpivot will be a success
Just returned from the sharepoint 2009 conference, I’m really excited about all the new BI stuff. One of the things I’m really excited about is powerpivot. As you might have guessed from the title, I’m going to elaborate on why I don’t think powerpivot will be a success, in the sense I don’t think it… Continue reading
-
Start SQL server from the command line
SQL server can be started and stoped from the command line like this: Start: net start mssqlserver Stop: net stop mssqlserver The same goes for Analysis Services. Start: net start “SQL Server Analysis Services (MSSQLSERVER)” Stop: net Stop “SQL Server Analysis Services (MSSQLSERVER)” Continue reading
-
Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object
I’ve been working a little with MS Analysis services lately. Yesterday I came across this error message: Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object.” The error message is self explaining. I did indeed have more than… Continue reading
