Archive for the ‘Analysis services 2005’ Category

Why I don’t think powerpivot will be a success

Posted on October 25, 2009, 4:54 am, by Claus, under Analysis services 2005, Sharepoint.

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 will [...]

No Comments | Read the rest of this entry »

Start SQL server from the command line

Posted on March 24, 2009, 1:32 pm, by Claus, under Analysis services 2005, MS SQL Server.

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)”

No Comments | Read the rest of this entry »

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

Posted on September 21, 2008, 11:13 pm, by Claus, under Analysis services 2005.

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 one cube, [...]

No Comments | Read the rest of this entry »