Microsoft SQL Server Community Samples: Analysis Services

This project contains SQL Server Analysis Services samples contributed by Microsoft, as well as samples created by MVPs and other members of the community.

If you would like to create new Analysis Services samples or make contributions to samples already posted, please contact the Project Admin.

Samples on this site:

Click the Downloads tab to obtain the source code for the following projects. Click the Documentation tab for a detailed list of the projects, including the version of SQL Server that is required, requirements, and when the project was last updated:

Activity Viewer
Provides functionality for SSAS similar to the SQL Server stored procedure sp_who and the kill command in Transact-SQL. Displays users, connections, and processes for an instance of Microsoft SQL Server Analysis Services. Use the tool to retrieve a list of these items and, if you want to, to stop a process.

Aggregation Manager
Lets you view, design, edit, and add aggregations based on the information collected in the query log.

ASCMD Stress testing Scripts
Enables a database administrator to execute an XMLA script, Multidimensional Expressions (MDX) query, or Data Mining Extensions (DMX) statement against an instance of Microsoft SQL Server Analysis Services, using the ASCMD command-line utility.

AS Load Simulation
Describes how to perform performance analysis on SQL Server 2005, and provides code and scripts for configuring and running load tests. See AS Load Sim Project page.

AS Query Generator
Describes how to perform performance analysis on SQL Server 2005, and provides code for configuring and running load tests. See AS Query Project page.

ASTrace2008
Creates a utility that runs as a Windows service, connecting to Analysis Services 2008 and 2008 R2 and logging trace events into a SQL Server table using the SQL Server Profiler format.

ASTrace2012
Creates a utility that runs as a Windows service, connecting to Analysis Services 2012 and logging trace events into a SQL Server table using the SQL Server Profiler format.

Analysis Services Upgrade Verification Tool (ASUV)
Helps you verify that your upgrade from SQL Server 2000 to SQL Server 2005 was successful.

Compress Many to Many
Creates a utility that helps you implements many-to-many compression techniques explained in the Query Performance Optimization Techniques white paper. May be useful in cubes that have many to many relationships, resulting in poor query performance.

Create Processing Log
Provides scripts that create and delete a system-wide processing log file.

Load Test Reports
Provides Reporting Services reports that display the results of the load tests generated by the solutions, AS Load Simulator and AS Query Generator.

Monitoring SSAS
Includes scripts (T-SQL, CMD and XMLA) and Integration Services packages for collecting various kinds of information about an Analysis Services server.

RSS Style Sheet
Contains formatting definitions that can be applied to solutions such as Monitoring SSAS, to dynamically change the color of a counter when the value changes, etc.

SSIS Package for Collecting SSAS DMV Data
Provides scripts for use in an SSIS package that uses DMVs to extract information about an instance of Analysis Services and write the information to a data collection server.

SSAS Monitoring Scripts for Management Data Warehouse
Provides just the scripts from the solution Monitoring SSAS that start and stop collection of data about an Analysis Services server.

SSAS Helper
Provides two code projects, one that creates an SSAS database using an MSBuild task, and one that creates a library with functions to work with AMO objects in Visual Studio 2008.

ResMon
Includes XMLA scripts that create a cube used for storing SSAS monitoring information. You can use the cube for analysis or to build dashboards. See ResMon Documentation page.

Additional related samples:

The following samples are not included on the Downloads page but are available on CodePlex and are useful for managing Analysis Services.

Analysis Services Load Balancing (ASLB)

BI System Monitor