Downloads

• OLAP Pivot Table Extensions on CodePlex
  

  Extend the functionality of PivotTables on Analysis Services cubes with this Excel add-in.

• MDX Script Analyzer on CodePlex
  

  Identify how much each calculated member, named set, and scoped assignment contributes to overall performance of an MDX query.

• Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for Developers
  
• Microsoft SQL Server 2008 Books Online
  

More downloads…

White Papers and Articles

White Papers

• Analysis Services Distinct Count Optimization
  
• Running Microsoft SSAS 2008 on Windows Server 2008 vs Windows Server 2003 and Memory Preallocation: Lessons Learned
  
• Reintroducing Usage-Based Optimization
  
• Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
  

Articles

• Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
  
• The LEVEL_UNIQUE_NAME Intrinsic Member Property
  
• The Unpopular SELECT Statement
  
• Large Analysis Database Migration
  

  by Robert Srna

• Integrating Visio 2007 with SQL Server Analysis Services
  

  by Dinesh Asanka

Videos and Virtual Labs

Microsoft

• Create and Publish a Data Cube for SQL Server Analysis Services 2008
  
• Delivering Analysis Services capabilities through Microsoft Office
  

• Viewing Analysis Services Data in Excel 2007 – SQL School Video
  

Podcasts and Webcasts

Podcasts

• Performance Improvements in SQL Server 2008 Analysis Services
  

Webcasts

• 24 Hours of SQL Server 2008: AS Design and Performance Improvements (Level 200)
  
• Advanced Manageability for SQL Server 2008 Analysis Services (Level 300)
  
• New Features in SQL Server 2008 for Developers (Level 200)
  
• Cube Wizard Improvements with Marcelo Blinder
  

Documentation

• Books Online: SQL Server 2008 Analysis Services – Multidimensional Data
  
• Books Online: SQL Server 2005 Analysis Services
  
• MDX Reference
  

Knowledge Base

• Search the Knowledge Base for “Analysis Services”
  

Code Samples and Public Projects

Product Team Samples

• Analysis Services Product Samples
• Solution for Collecting Analysis Services Performance Data
• Analysis Services Activity Viewer 2008

Improve the functionality of the SQL Server Analysis Services Activity Monitor.

Community Samples

• Microsoft SQL Server Community Samples: Analysis Services.
• PowerSSAS - Navigate an Analysis Services server like a drive, by MVP Darren Gosbell.
• BIDS Helper - Enhance the functionality of BIDS with this Hero award winning Visual Studio.net add-in.
• Stored Procedure Project - Improve your stored procedures with these extensions to Analysis Services and example source code.

Search

• Search CodePlex projects for Analysis Services content
• Search Code Gallery for Analysis Services content
• Search Solution Finder for Analysis Services content

Blog Postings and Articles

• EXISTING AND NONEMPTY MDX nugget
  

  by MVP Chris Webb

• SQL Server Analysis Services Concepts
  

  by MVP Midal Arabi

• Using MDX to browse the file system
  

  by MVP Chris Webb

• Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
  

  from SQL CAT

• Implementing Real Analysis Services DrillDown in a Reporting Services Report when Analysis Services is used as the data source
  

  by MVP Chris Webb

MSDN Forums

• SQL Server 2008 Analysis Services
  
• SQL Server Documentation
  
• More SQL Server forums
  

Web Sites

• Microsoft SQL Server Community
• SQL Server on Facebook
• Analysis Services content on TechNet Edge
• SQLServerCentral
• DatabaseWeekly
• SQL Server Analysis Services webcasts, videos, virtual labs
• Analysis Services Resource Hub
• Analysis Services and MDX
• The OLAP Report
• OfficeDeveloper.net

Books

• Microsoft SQL Server 2008 Analysis Services Unleashed
  

  by Irina Gorbach, Alexander Berger, Edward Melomed (Paperback, 2008)

• Professional Microsoft SQL Server Analysis Services 2008 with MDX
  

  by Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, Matt Carroll, Denny Lee (Paperback, 2008)

• SQL Server 2008 Analysis Services Step by Step
  

  by Scott Cameron (Paperback, 2008)

• MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
  

  by George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi (Paperback, 2005)