Elon's Blog

Stuff that may be of use to someone…

Top 10 Best Practices for Microsoft SQL Server 2008 Analysis Services

Posted by Elon B. on January 4, 2010

I was fortunate enough to attend Microsoft’s Tech-Ed event in Berlin in Nov 2009 and attended a session given by Markus Raatz, which was very informative.

Some interesting topic areas covered included:

  • Attribute Relationships
  • Dimensions
  • Measure Groups
  • ROLAP and MOLAP storage
  • Aggregations
  • User defined Hierachies
  • Partitions
  • Data Providers and
  • Error Handling

He also mentioned visiting the Project REAL site for more information:

Project REAL is a cooperative effort between Microsoft and a number of technology partners in the business intelligence (BI) industry to build on actual customer scenarios to discover best practices for creating BI applications based on SQL Server 2005. Project REAL uses authentic customer data to work through customer deployment issues and to address the full range of real-world challenges that companies face when analyzing large data sets.

His PowerPoint 2007 presentation deck can be found here.

One Response to “Top 10 Best Practices for Microsoft SQL Server 2008 Analysis Services”

  1. techwoo said

    Top 10 Best Practices for Microsoft SQL Server 2008 Analysis Services .Thanks for nice post.I added to my twitter.


Please Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: