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

SSAS-Info.com website update information for January 2008.

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

SSAS Unofficial News

• MS released update (January 2008) for SQL Server 2005 Best Practices Analyzer (BPA) 

 About new BPA. In the last release, only a few rules for Analysis Services would be displayed.  These were mainly around security.  With this release, we detect potential issues with the design of your cubes.  If you have taken a look at SQL Server 2008, you’ll see that these are the same warnings you’ll find in Business Intelligence Development Studio.  Thus, the recommendations from SQL BPA will be perfectly in sync with the recommendations from SQL Server 2008. 

• MDX Studio new beta release 0.2.7 available for download

About new MDX Studio release. This release adds a single but very important and requested feature - integration of Analysis Services trace into MDX Studio.

SSAS Articles

• Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
• Building a better DMV
• Dimensional Model Components: Dimensions Part I
• Finding and killing SSAS Sessions
• SSAS: Acquiring Locks using XML/A from SSMS - Part 2
• Dimension Security Tips, Tricks and Problems
• SSAS 2008 Upgrade Consideration: ODBC Data Sources from Analysis Services 2000 are not migrated
• Sample Robocopy Script to customer synchronize Analysis Services databases
• Querying Dimension Members In Analysis Services
• SSAS: Acquiring Locks using XML/A from SSMS
• Getting the Current Day in MDX
• Connecting Informatica with MS-OLAP
• Discovering your MetaData
• MDX Numeric Functions: The Max() Function

Webcasts

• Mastering Time Series Prediction with SQL Server 2008 Data Mining
• Richard Tkachuk discusses the SQL CAT team, working with Analysis Services
• Mining for Quality: Apply Adaptive Data Quality with SQL Server Data Mining