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

Special offer:

What: SSWUG.org Business Intelligence Virtual Conference 2008
When: September 24-26, 2008
Where: Virtual, straight from your desktop
Event Link: http://www.vconferenceonline.com/business-intelligence/

The SSWUG.ORG Business Intelligence Virtual Conference provides a unique experience to make sure you get the information you need from some of the industry's leading experts. Matthew Roche, Chief Software Architect of BI consulting firm Integral Thought & Memory, is our esteemed conference chair for this event and has put together a list of great speakers. Donald Farmer, Brian Knight, Ted Malone and Erik Veerman are just some of the speakers who are presenting. Sessions being presented include SSAS 101, Patterns for SSIS Configurations, Intro to SQL Server Data Mining, Designing a BI Solution for Performance and so much more.

As a member of SSAS-info, use this VIP code (xxxxxx) to receive $10 off your registration. (code available just to the newsletter subscribers)

Contest

Win a free pass to SSWUG.ORG BI Virtual Conference

SSAS News

• Microsoft Announces SQL Server 2008 RTM
• SQL Server 2008 Beta Exam: 71-452: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008  
• MS released Cumulative update package 9 for SQL Server 2005 Service Pack 2
• BIDS Helper version 1.3 released for SQL Server 2005 and 2008
• SSWUG.ORG BI Virtual Conference - September 24-26, 2008

SSAS Papers

SSAS 2005 Articles

• AMO - Microsoft Analysis Services 2005: Displaying grid using ADOMD.NET and MDX
• Connectivity - Yet Another Post About Analysis Services HTTP Connectivity
• Data mining - Time Series Reporting Stored Procedure 
• Data mining - Explore Time Series enhancements in SQL Server 2008 
• Data mining - Decision Trees in SSAS2005 and Excel 2007
• Excel - Using Excel & Excel Services with SQL Server Analysis Services 2008
• Management - Generating large numbers of partitions using Excel 
• Management - Misleading partition row count in Aggregation Design Wizard when measure group is at a higher level than its source granularity
• Management - How To Define Measure Group Partitions in SQL Server Analysis Services (SSAS) 2005
• Management - How To Implement Proactive Caching in SQL Server Analysis Services (SSAS) 2005
• Management - How To Use the Analysis Services Execute DDL Task in SSIS 2005
• Management - SQL Server Databases and Cubes on one Server
• MDX - Attribute Member Keys – Pt 1: Introduction and Simple Keys 
• MDX - Product Sales, Top and BottomCount in the same report 
• MDX - How to round detail rows and totals? 
• MDX - Intrinsic Member Properties: The MEMBER_UNIQUE_NAME Property 
• MDX - Error Wrap in MDX 
• Reporting services - Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part II  

SSAS 2008 Articles

• Nasty SSAS 2008 Bug

SSAS Client Tools

SSAS Tools

• Analysis Services Parent-Child Dimension Table Naturalizer 
• OLAPQueryLog analysis  

Webcasts

• Webcast - Video - SSAS 112 - Aggregation Basics in SSAS 2008 
• Webcast - Video - SSAS 111 - Aggregations Basics in SSAS 2005
• Webcast - Performance Improvements in SQL Server 2008 Analysis Services - interview with Richard Tkachuk
• Webcast - Video - SSAS 110 - Dimension Usage
• Webcast - Viewing Analysis Services Data in Excel 2007 - SQL School Video
• Webcast - Video - SSAS 109 - Attribute Relationships
• Webcast - Video - SSAS 108 - Creating Hierarchies

SSAS Implementations

• Microsoft SQL Server 2008 Data Mining Services - Table Analysis Tools for the claud

SSAS Jobs

 SSAS FAQ

SSAS Consultants

Are you a SSAS Consultant? If so, please add info about your services to our website so potential clients can find out about you.

Do not forget to rate the articles!