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

Please add our newsletter address to safe senders list!

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

SSAS-Info.com Poll

Do you prefix your DW tables with dim and fact?

Results for June 28, 2008:

71.7% Yes, and I like it 
17.4% No, that is not a good practice 
 8.7% No opinion 
 2.2% I inherited DW with prefixes and I don't like it 

Cast your vote at http://www.ssas-info.com

Announcements

• Annual BI Survey 8 by Nigel Pendse - please participate 
• Microsoft Business Intelligence Conference 2008. Registration will open July 8th
• MDX Studio 0.2.9.1 released - July 26, 2008 

SSAS News

• MS released Cumulative update package 8 for SQL Server 2005 Service Pack 2
• Microsoft released SQL Server 2008 Release Candidate 0 (RC0)

SSAS 2005 Articles

• AMO - AMO - Delete All Partitions From a Database 
• Design - Null processing of measures in SSAS2005 
• Design - Identifying intra-dimensional members relationship and reducing cube sparsity in Analysis Services 2005 SP2 : Cube design tip
• Excel - Extracting data from OLAP to Excel 12.0 settings
• Excel - Excel 2007 Pivot Table with SharePoint On Vista PC - works good after SP1
• Local Cube - Complete OLAP infrastructure without Microsoft Analysis Services, parts 1-3 
• MDX - Aggregate(), Sum() functions using calculated members does not work in Analysis Services 2005 SP2 (9.00.3042.00 version) but works in Analysis Services 2000 SP4 
• MDX - Named Sets and TopCount, some thoughts of how this works 
• MDX - Intrinsic Member Properties: The MEMBER_KEY Property
• MDX - Counting distinct values in MDX
• MDX - Follow up on NextAnalytics challenge 
• MDX - MDX answer to NextAnalytics challenge 
• Reporting Services - Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part II 
• Reporting Services - Mastering OLAP Reports: Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
• Reporting Services - How to implement cascading parameters in a SQL Services Reporting Services MDX Report
• Time Dimension - Creating Time Dimension in Microsoft Analysis Services
• Time Dimension - Handling Multiple Calendars with a M2M Scenario
• Time Dimension - Demystifying SSAS Time Dimension Attribute Types
• Performance Point - Data-driven Time filters in PerformancePoint M&A

SSAS 2008 Articles

• Policy-based management almost makes it to AS2008
• Using the Caption property with Calculated Members in AS2008
• Dynamic Named Sets in Analysis Service 2008
• Microsoft SQL Server 2008 RC0 - New Adventure Works Sample Databases for SSAS
• SSAS 2008 RC0 - New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets - DMVs

SSAS Client Tools

SSAS Tools

Webcasts

• Performance Point - PerformancePoint Server - Monitoring & Analytics Tech Night

SSAS Implementations

• Experience - SQL Server MVP Chris Webb discusses MDX and Analysis Services
• Experience - Rafal Lukawiecki on TechEd, Data Mining, SQL Server and more
• Experience - SQL Data Mining: Interview with Wee Hyong
• Live demos - SQL Minds Data Mining Companion - online tool to perform data mining related operations
• Live demos - SQL Minds BI Companion - online SSAS cube browser

SSAS Jobs

• Sr. Microsoft Business Intelligence Consultant - Charlotte, NC

 SSAS FAQ

• MDX - MDX query for the count of customers for whom the earliest sale in the selected time period (2002 and 2003) occurred in a particular Product Category 

Do not forget to rate the articles!