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.