SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

This newsletter can be accessed online at:
http://www.ssas-info.com/newsletters/website_update/ssas-info.com_december_2007.html
 

SSAS Unofficial News

• MS released Cumulative update package 5 for SQL Server 2005 Service Pack 2
• SSAS: ASSP 1.2 Released
• New MS Paper: Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

SSAS Articles on the web

• Discovering your MetaData
• MDX Numeric Functions: The Max() Function
• Local cubes in management studio
• Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
• SQL 2005: OpenRowset, Dynamic MDX and Variable Scope
• CLR Stored Procedures in Sql Server Analysis Services (SSAS)
• MDX and partitioning
• Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Command
• Manage Unknown Members in Analysis Services 2005, Part II
• Why you should learn more about the MDX Generate function
• Analysis Services 2005 Aggregation Design Strategy
• Switching Data Sources in Excel 2007
• Comparing MDX Query Results With Tablediff
• Multiselect in different clients illustrated
• Set Functions: The .AllMembers Function

Webcasts on Analysis Services

• Channel 9 Screencast - Introducing the Table Analysis Tool for Excel 2007
• Channel 9 Screencast - Introducing Data Mining
• Channel 9 screencast - More Analysis with Microsoft Excel 2007
• Channel 9 screencast - Introducing Cube Calculations
• Channel 9 Screencast - Using the Cube Wizard
• Channel 9 Screencast - Advanced Dimension Design
• Channel 9 Screencast - Designing Dimensions
• Channel 9 Screencast - Implementing Slowly Changing Dimensions in the Data Flow
• Channel 9 Screencast - Exploring Analysis Features of Microsoft Excel 2007