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_february_2008.html

Website Poll

Poll question: Which conference are you planning to attend?
Poll results at the time of sending this newsletter:

• 62.5% - MS BI
• 16.8% - None
• 9.4%   - Undecided
• 6.3%  - SQL PASS
• 3.1% - Both

To see latest results and to vote please visit http://www.ssas-info.com

SSAS Unofficial News

• MS released Cumulative update package 6 for SQL Server 2005 Service Pack 2
• MS released SQL Server 2008 February CTP6 

SSAS 2005 Articles

• Using Non_Empty_Behavior With YTD calculations 
• Parameterising Calculated Measure Definitions
• Support Parameterization from Analysis Services
• Building Cubes with SQL Server 2005 Analysis Services
• Calculated members vs assignments to real members
• The many names of attribute relations
• SSAS Performance Seeker Bag Pack
• The new ".currentmember" behavior with subselect in SSAS 2005 sp2
• Cell Security and the Formula Engine Cache
• Dimensional Model Components: Dimensions Part II
• Performance, Named Sets, Calculated Measure, PerformancePoint and ProClarity
• Calling MDX from a SQL Server Stored Procedure
• Updating your Report Model
• Visual Totals in MDX and Role Security
• Last Non Empty Affairs
• Common Questions Around Excel 2007 OLAP PivotTables
• Check List for Performance Optimisation in SQL Server Analysis Service 2005
• MDX Numeric Functions: The Min() Function
• Optimize CROSSJOINS with NONEMPTY
• OBIEE Hybrid OLAP Reporting using MS Analysis Services & Oracle

SSAS 2008 Articles

• Cube Squared: Migrating Analysis Services to the SQL Server 2008 Platform, Part 1 of 2 
• SSAS 2008 Katmai Change Summary  
• SSAS 2008 MOLAP Writeback (2)
• SSAS 2008: What's new in the Schema Rowsets?
• SQL Server 2008 February CTP6 - Read-only SSAS Shared Scale-out and other changes
• Connecting to SSAS 2008
• Configuring MOLAP writeback

Webcasts

• Data mining with SQL Server 2005
• Microsoft BI Overview
• Office 2007 BI capabilities, Excel, Sharepoint/Excel Services
• Developing More Intelligent Applications with Data Mining
• Real-Time Business Intelligence (BI) with SQL Server 2005
• Predictive Analytics with Microsoft SQL Server 2005
• Technet presentation - Upgrading to SQL Server 2005 Analysis Services
• YouTube video - how SSAS is used

Blogs

• James Rogers Blog
• Michel Caradec's BI Blog

[USERTRACK]