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 News

• MDX Studio 0.4.2 released - July 29, 2008
• Microsoft to Acquire DATAllegro - provider of DW appliances
• Microsoft Business Intelligence Conference 2008. Registration open, Session list available. Forum to talk about BI conference is here. 

SSAS Papers

• Functionality & Performance Testing Analysis Services 2005 with Teradata v12

SSAS 2005 Articles

• AMO - Win/Loss chart as dynamic image created in SSAS stored procedure
• AMO - Some more samples for data aware images created in a stored procedure
• AMO - Returning an image from an SSAS stored procedure
• Design - BI Architecture and Design Guidelines
• Design - Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
• Design - Dimension Attributes: Introduction and Overview, Part V
• Management - SSAS Deployment Wizard Retaining Permissions
• Management - Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned
• Management - Creating an Analysis Services Cube with Visual Studio 2008 - Parts 1 and 2
• Management - Manage traces in SQL Server 2005 Analysis Services with XMLA commands
• MDX - Product Volatility: Optimizing MDX with MDX Studio
• MDX - What happend to the top 10 products previous years ?
• MDX - MDX ratio of "current parent" issue
• MDX - Product Volatility in Adventure Works
• MDX - Intrinsic Member Properties: The MEMBER_NAME Property
• MDX - Some more thoughts on quantiles...
• MDX - NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
• MDX - Binomial distribution for a KPI status (parts 1 and 2)
• Parent-Child - Recursive hierarchies or non recursive, pros and cons
• Reporting Services - Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I
• Reporting Services - SSRS Report Against a SSAS Parent Hierarchy
• Data warehouse - Value-Add: Data Warehousing & Analysis Services Cube Storage Estimates
• Data warehouse - Best Practices for Data Warehousing with SQL Server 2008

SSAS 2008 Articles

• Named Sets, AutoExists and Katmai
• Performance Improvements for MDX in SQL Server 2008 Analysis Services
• Dynamically generating session calculated members in code with Analysis Services 2008

SSAS Client Tools

• Data Dynamics Analysis
• SoftPro CubePlayer
• SoftPro Manager - free SSAS 2000 Client
• Miner3D

SSAS Tools

• AS Validate Users utility - to avoid "no mapping between account names and security IDs was done" error
• Kalido Universal Information Director
• MDX Studio Online - format and parse MDX queries

Webcasts

• Webcast - Webcast - SSAS 107 - Creating Dimensions
• Webcast - Webcast - Microsoft Office Excel and Microsoft SQL Server Analysis Services: An In-Depth Look at Integration
• Webcast - Webcast - SSAS 106 - Basic Deploying, Processing, and Browsing
• Webcast - Webcast - Advanced SQL Server 2005 Analysis Services Workshop
• Webcast - SSAS 105 - The Cube Wizard - SSAS 2008
• Webcast - SSAS 104 - The Cube Wizard - SSAS 2005
• Webcast - SSAS 103 - Data Source Views
• Webcast - SSAS 102 - Creating Projects and Data Sources
• Webcast - SSAS 101 - Introduction to Analysis Services
• Webcast - Webcast - Avoiding Common Analysis Services Design Problems
• Webcast - Video: Did you know? SQL Server 2008 includes Dimension Designer Enhancements (SSAS)
• Data Mining - Webcast - The Subtle Powers of Data Mining Algorithms

SSAS Implementations

SSAS Jobs

 SSAS FAQ

Do not forget to rate the articles!