SQL Server Analysis Services Samples

Microsoft SQL Server 2005 Analysis Services (SSAS) includes the following sample applications that you can use to learn about working with the latest version of Analysis Services.

Note

SQL Server 2005 Business Intelligence Development Studio is not supported on computers running on the IA64 platform; the 64-bit development environment is supported on x64-based platforms. SQL Server 2005 samples can be modified and run on computers running on either x86 or x64-based platforms while databases used by the samples are deployed on an IA64 platform.

The following table describes the Analysis Services samples.

Name Description

Readme for Activity Viewer Sample

The Activity Viewer sample is a tool that displays users, connections, and processes for an instance of Analysis Services.

Readme for AMOBrowser Sample

The AMOBrowser sample lets you use Analysis Management Objects (AMO) objects to connect to an Analysis Services server, and then browse different AMO objects and their properties.

Readme for Backup and Restore Sample

The Backup and Restore sample lets you use Analysis Management Objects (AMO) objects to connect to an Analysis Services server.

Readme for DisplayObjectNames Sample

The DisplayObjectNames sample lets you use Analysis Management Objects (AMO) objects to connect to an Analysis Services server and then display the names of some of the AMO objects.

Readme for AMOAdventureWorks Sample

This is a sample C# program that illustrates the use of the Analysis Management Objects (AMO) to create complex OLAP cubes.

Data Mining Web Controls Library

Data Mining Web Controls Library is a library intended to extend the data mining user experience in Analysis Services to the Web.

Readme for SQL Server Plug-In Algorithms

The Data Mining Algorithm sample allows data mining algorithm developers using Analysis Services to concentrate on the algorithm rather than on the implementation issues and the data mining viewer plug-in sample allows third-party algorithm providers to use their own viewers to display their new discovered patterns.

Readme For Ascmd Command-line Utility Sample

The ascmd command-line utility enables a database administrator to execute an XMLA script, MDX query, or DMX statement against an instance of Analysis Services.

Readme for AS Simple Sample

AS Simple Sample is a sample C# program that illustrates the use of the Analysis Management Objects (AMO) to create complex OLAP cubes and the use of ADOMD.Net to access the contents of the newly created cubes.

Readme for Analysis Services Upgrade Verification Tool Sample

The Analysis Services Upgrade Verification Tool lets you compare Multidimensional Expressions (MDX) query results and performance between a Microsoft database and a Microsoft SQL Server 2005 Analysis Services (SSAS) database. This tool helps you verify that your upgrade from SQL Server 2000 to SQL Server 2005 was successful.

Readme for Aggregation Manager Sample

Aggregation Manager is a sample application that lets you view, design, edit, and add aggregations based on the information collected in the query log.

Readme for ASTrace Utility Sample

The ASTrace utility provides you with ability to capture an Analysis Services trace and log it into a SQL Server table. The table can be queried later or read using SQL Server Profiler.

See Also

Tasks

Installing Samples

Other Resources

Samples

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006

New content:
  • Added four new samples.

14 April 2006

New content:
  • Added note on availability for IA64 platform.