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 |
|---|---|
The Activity Viewer sample is a tool that displays users, connections, and processes for an instance of Analysis Services. |
|
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. |
|
The Backup and Restore sample lets you use Analysis Management Objects (AMO) objects to connect to an Analysis Services server. |
|
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. |
|
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 is a library intended to extend the data mining user experience in Analysis Services to the Web. |
|
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. |
|
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. |
|
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. |
Aggregation Manager is a sample application that lets you view, design, edit, and add aggregations based on the information collected in the query log. |
|
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
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
12 December 2006 |
|
14 April 2006 |
|