SSAS-Info.com December 2007
SSAS-Info.com website update information for December 2007.
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