Monthly Archives: February 2007

Aggregation Manager (or Utility) for Analysis Services 2005

One of the new cool things that comes with SP2 is the Aggregation Manager for Analysis Services. It doesn’t come with the actual service pack install, you’ll have to get it through a separate download. Go here: http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en Download SQLServerSamples.msi … Continue reading

Posted in Uncategorized | Leave a comment

Advanced MDX Application Topics – MDX Solutions

While surfing today I found an entire chaper from "MDX Solutions: With Microsoft SQL Server Analysis Services" available online. Chapter 4: Advanced MDX Application Topics – http://media.wiley.com/product_data/excerpt/67/04714004/0471400467.pdf It’s from the 2001 printing; there is a 2006 edition out and I … Continue reading

Posted in Uncategorized | Leave a comment

“Errors in the metadata manager. An error occurred when instantiating a metadata object from the file…”

When restoring a backup I received the following error: "Errors in the metadata manager. An error occurred when instantiating a metadata object from the file…"     Error This is annoying. It’s been happening to every one of my backups. … Continue reading

Posted in Uncategorized | 10 Comments

New phone fun

Got a Blackjack so I snapped a few pictures…     Book collection   The Desk    

Posted in Uncategorized | Leave a comment

Activity Viewer – kill queries in Analysis Services

One of the neat things about SSAS2005 is the ability to tell what’s going on under the hood. This was sorely lacking in AS2000 and resulted in many restarts of the OLAP service to clear things up.   Microsoft has … Continue reading

Posted in Uncategorized | Leave a comment

Analysis Services 2005 Performance Guide now available

Haven’t had a chance to dig through it yet, but I’ve been waiting months for this.   http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc   Doesn’t look like I’m going to get much work done today…      

Posted in Uncategorized | Leave a comment