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

This newsletter can be accessed online at:
http://www.ssas-info.com/analysis-services-newsletters/45-site

Announcements

In April IT-Workplace released Intelligencia Query for BIDS and Reporting Services.  Intelligencia Query combines a state-of-the-art query builder with custom data extensions to significantly improve the functionality and productivity of BIDS and Reporting Services. With IQ you are able to render any piece of valid MDX without having to conform to the restrictions imposed by the standard Reporting Services environment. Read more...

SSAS News

• MS released Cumulative update package 7 for SQL Server 2005 Service Pack 2

SSAS 2005 Articles

• AMO - SSAS Stored Procedures - connecting to the transactional data source
• Design - SSAS Beginner’s Guide: Storage Structure
• Design - Dimension Attributes: Introduction and Overview, Part II
• MDX - Currency formats: should they be tied to language?
• MDX - Semi Additive Measures using SQL Server Standard
• MDX - Leaves() : Works for regular hierarchies but not for parent child hierarchies
• MDX - SSAS MDX Round = Banker's Rounding
• MDX - Set Functions: The StripCalculatedMembers() Function
• MDX - Can your sum be a subtraction? Or can you avoid it altogether
• MDX - Regular Expressions for MDX
• MDX - Subselects, SCOPEs and hierarchy navigation MDX functions
• Parent-Child: Parent-Child Dimension in a correct DW? Easy
• Parent-Child: Parent Child Attribute performance woes in SQL Server 2005 SP2: A case study
• Performance tuning: powerSSAS: Getting Aggregations for a particular Attribute
• Performance tuning: Analysis Services 2005 Design Best Practices - Cubes & MDX
• Reporting Services: Support Parameterization from Analysis Services – Parameter Defaults
• Reporting Services: Passing MDX parameters in Reporting Services reports

SSAS 2008 Articles

SSAS Client Tools

• ComOps BI
• Webdashboard - Dashboarding made easy

SSAS Tools

• Intelligencia Query for BIDS and Reporting Services
• SqlSpec - documentation tool for Analysis Services 2005
• Transact Sql Server Analysis Services Metadata

Webcasts

• Virtual Lab: Data Mining with SQL Server 2008
• Virtual Lab: SQL Server 2008 Analysis Services- Delivering Analysis Services capabilities through Microsoft Office
• Virtual Lab: SQL Server Analysis Services- Managing Analysis Services Solutions
• TechNet Virtual Lab: Business Intelligence- Excel 2007 PivotTables and Analysis Services

SSAS Implementations

• Denny Lee from SQL CAT: Data Mining applied to medical research
• Podcast - Val Matison Gives Us Business Intelligence!
• Business Intelligence (BI) for Less Than $25k 

Don't forget to rate the articles!