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

In a middle of the March there were many behind the scene changes done to SSAS-Info.com and as a result of that all page URLs were changed. If you have links to our website, please update them. If you had RSS subscription to our news or FAQs, please re-subscribe as address changed.

We added more interactivity to our site - now you can leave comments and rate articles, software, FAQs, news, etc.

We added new section SSAS implementations. If you know any website with live SSAS access or with nice video demo of SSAS implementation in the real life, please send us a link.

SSAS News

• (New) MS released new set of Analysis Services 2005/2008 samples  

SSAS 2005 Articles

• AMO - How To Show the Last Update Date of the SSAS Cube
• AMO - Analysis Services 2005 and 2008 with PowerShell - it works
• AMO - Using PowerShell to update the case of Attribute names
• AMO - SSIS Package to Back Up SSAS Databases
• Connectivity - Performance Testing of Teradata v12 with SQL Server 2005 Analysis Services
• Data Mining - Unwinding MDX Flattening Semantics with DMX
• Design - Many to many relations in natural hierarchies
• Design - Measures and calculations in cubes without natural hierarchies
• Design - More Comments on attribute relations and calculations
• Design - Analysis Services: Should you use many-to-many dimensions?
• Excel - Setting up Excel Services to Refresh Workbooks When Opened
• Management - Forget SQL Management Studio, Stick to BIDS
• Management - UPDATE CUBE in subcubes
• Management - Analysis Services Project Configurations
• Management - SQL 2005, SSAS 2005: Using ascmd.exe To Create SQLAgent Jobs That Give You Completion Status
• Management - Analysis Services Synchronization Best Practices
• MDX - MDX Named Sets in SQL Server 2005/2008
• MDX - The Baker's Dozen: 13 Tips for Querying OLAP Databases with MDX
• MDX - Set Functions: The AddCalculatedMembers() Function
• Parent-Child - Including Child Members Multiple Places in a Parent-Child Hierarchy
• Parent-Child - Dimension Security Issues with Excel 2007 and SSAS 2005 Parent-Child Hierarchies
• Parent-Child - Simulating Parent-Child dimension with data on leaf members only
• Performance tuning - Take advantage of FE caching to optimize MDX performance 
• Performance tuning - Visualising Analysis Services Trace Information in Reporting Services
• Reporting services - Parameterization from Analysis Services – Cascading Picklists
• Reporting services - Current Date Parts for SSRS Reports using SSAS Cubes
• Reporting services - Using Reporting Services (SSRS) with SSAS data

SSAS 2008 Articles

• SSAS 2008 CTP6 - new DMV $SYSTEM.DISCOVER_OBJECT_ACTIVITY
• Killing Queries From Reporting Services
• Analysis Services 2008 Personalization Extensions
• Dynamic Named Sets in SQL Server Analysis Service 2008

Webcasts

• SSAS 2008 MS Virtual Lab: Dimension Designer and Best Practice Alerts 
• Video of Excel Pivot Tables  

SSAS Implementations

• Richard Lee live demo site with SSAS, SharePoint and Excel Services

Dont forget to rate articles after reading!