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

What front end are you using for SSAS database?

Results for May 31, 2008:

26.7% Microsoft Excel
24.4% Proclarity
17.6% Microsoft Reporting Services
13.7% Other
 6.9% In house build software
 4.6% Panorama Novaview
 1.5% Strategy Companion Analyzer
 1.5% PivotView OLAP Client 
 1.5% Cubeslice
 0.8% Intelligencia Olap Controls
 0.8% Business Objects - Voyager 

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

Talk about poll results in our forum.

Announcements

• June 4th webcast: Data Modeling for Business Intelligence with Microsoft SQL Server
• Free Solid Quality Mentors webcast - June 4, 2008- Craig Utley: Avoiding Common Analysis Services Design Problems

SSAS News

SSAS Cheat Sheets

Formatted list (PDF) of MDX queries. This is work in progress and the list will be updated.

• MDX Various Queries Cheat Sheet
• MDX Error handling Cheat Sheet
• SCOPE MDX Cheat Sheet
• Time MDX Cheat Sheets

SSAS 2005 Articles

• AMO - Code : utility code for converting cellset to a data table
• AMO - SSAS: Reporting on Metadata
• AMO - Managing SQL Analysis Service Objects with SSIS and AMO
• Connectivity - LINQ to MDX
• Data Mining - Data mining - Microsoft Business Intelligence with Numerical Libraries
• Design - Using TinyInt as keys in Analysis Services
• Design - Dimension Attributes: Introduction and Overview, Part IV
• Design - Star vs. Snowflake in OLAP Land
• Design - Intrinsic Member Properties: The MEMBER_CAPTION Property
• Design - Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
• Design - Dimension Attributes: Introduction and Overview, Part III
• Design - KPIs in Analysis Services
• MDX - SIMPLE MDXes for time periods
• MDX - Division by null and zero in MDX
• MDX - Ranking results from MDX queries
• MDX - Very Customed Aggregation
• Parent-Child - Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
• Reporting Services - How to implement cascading parameters in a SQL Services Reporting Services MDX Report
• Reporting Services - Creating a Report Model based on an Analysis Cube – Pros and Cons
• Security - Cell Security: when Read permissions are actually Read Contingent
• Security - Microsoft BI with Constrained Kerberos Delegation
• Security - Enhancing Analysis 2005 Security - Revoking Domain Admin and Local Admin from Built in Admin role
• Security - powerSSAS: Listing Role information
• Time Dimension - Handling Multiple Calendars with a M2M Scenario

SSAS 2008 Articles

SSAS Client Tools

SSAS Tools

• xSQL Documenter - SSAS Documentations
• Analysis Services Browser Views Add-in
• Persisting SSAS OLAP Roles In Project Server 2007

Webcasts

• Webcast - Webcast: SQL Server 2008 Analysis Services Design and Performance Improvements
• Virtual Lab - TechNet Virtual Lab: Building Integrated Business Intelligence Solutions Leveraging SQL Server 2005 and SharePoint Server 2007 
• Data Mining Webcast - Using Data Mining in Your IT Systems (Part 2)
• Data Mining Webcast -  Using Data Mining in Your IT Systems (Part 1)
• Data Mining Webcast - Video presentation - Working with Data Mining
• Data Mining Webcast - Video presentation - Introduction to Data Mining
• Data Mining Webcast - TechNet Webcast: 24 Hours of SQL Server 2008: Data Mining

SSAS Implementations

SSAS Jobs

• Sr BI/Data warehouse positions NYC/Tampa  

 SSAS FAQ

• MDX - How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?
• MDX - How do I create a Rolling 12 Months Accumulated Sum that can show a trend without seasonal variations
• MDX - How do I group dimension members dynamically in MDX?
• MDX - How do I check for the top level in a dimension to avoid division by an nonexsting parent(-1.#INF)
• MDX - How do I check for division by zero and null to avoid -1.#INF in cells
• Management - How to fix dimension processing error 'mdprocessdim.cpp line 3429 function MDProcessPropertyJob'

Do not forget to rate the articles!