Analysis Services для начинающих

Полезные ссылки для изучающих Analysis Services:

An Introduction to OLAP in SQL Server 2005
http://www.devx.com/dbzone/Article/21410

Руководство SQL Server 2005 Analysis Services
http://msdn.microsoft.com/ru-ru/library/ms175609(SQL.90).aspx
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1262093,00.html

Руководство по метрикам производительности
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1185283,00.html?bucket=ETA&topic=301334

Для тех кто не знает что такое профайлер и как им пользоваться
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1171978_tax301334,00.html?adg=301324&bucket=ETA

Overview of the Analysis Services Development and Management Environments
http://msdn.microsoft.com/en-us/library/ms345127(SQL.90).aspx

Использование профайлера для тюнинга Analysis Services
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1186197,00.html?bucket=ETA&topic=301334

Выявление проблем с помощью профайлера, пошаговое руководство
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1248026,00.html


Manage traces in SQL Server 2005 Analysis Services with XMLA commands
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1319949,00.html

How To Use the Analysis Services Processing Task in SQL Server 2005 Integration Services SSIS
http://www.mssqltips.com/tip.asp?tip=1560

Microsoft SQL Server Community Projects & Samples
http://www.codeplex.com/SqlServerSamples#ssas

Создание кубов Analysis Services в Visual Studio 2008 - Part 1
http://www.packtpub.com/article/creating-analysis-services-cube-visual-studio-2008-part1

Создание кубов Analysis Services в Visual Studio 2008 - Part 2
http://www.packtpub.com/article/creating-analysis-services-cube-visual-studio-2008-part2

Introduction to the Unified Dimensional Model (UDM)
http://msdn.microsoft.com/en-us/library/ms345143(SQL.90).aspx

Блог http://bi-on-sql-server.blogspot.com/

Автоматизация временного анализа в Analysis Services 2005
http://www.osp.ru/win2000/2005/08/380206/

SSAS 2005: Cube Performance Tuning Lessons Learned
http://www.sqlmag.com/Article/ArticleID/100645/100645.html


How to process SQL Server 2005 Analysis Services for data availability
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1311987,00.html

Сравнение OLAP и OLTP
http://www.alagad.com/go/blog-entry/data-warehousing-part-1-olap-and-oltp

13 советов по MDX
http://www.devx.com/codemag/Article/37460

Mastering OLAP Reporting: Reporting with Analysis Services KPIs
http://www.databasejournal.com/features/mssql/article.php/3605826/Mastering-OLAP-Reporting--Reporting-with-Analysis-Services-KPIs.htm

An analysis of what the often misused OLAP term is supposed to mean
http://www.olapreport.com/fasmi.htm

Using Neural Networks and OLAP Tools to Make Business Decisions
http://www.developer.com/db/article.php/3763726

Статьи про OLAP
http://www.programmersheaven.com/tags/OLAP/Articles/

OLAP and Data Warehousing (The Problem and Solution)
http://www.databasejournal.com/features/mssql/article.php/1457031/OLAP-and-Data-Warehousing-The-Problem-and-Solution.htm

OLAP Design Best Practices for Analysis Services 2005
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/olapdbpssas2005.mspx