경영정보 이야기

Sample name

Description

ActivityViewer

Activity Viewer sample는 사용자, Connection 그리고 AS2005의 프로세스를 보여주는 도구입니다.

이 도구는 필요하다면 위 목록의 프로세스를 정지시킬 수 있습니다.

AggregationManager

Aggregastion Manager는 사용자가 쿼리 로그(Query log)에 수집된 정보를 기반으로 집계(Aggregation)를 검토, 디자인, 수정 및 추가 할 수 있습니다.

ASCMD

The ascmd command-line utility enables a database administrator to execute an XMLA script, MDX query, or DMX statement against an instance of Microsoft SQL Server 2005 Analysis Services (SSAS). This command-line utility contains functionality similar to the sqlcmd Utility that is included with SQL Server 2005, but for Analysis Services. The execution results of the script, query, or statement can be stored in a file together with relevant SQL Server Profiler trace information.

New in the July 2006 release of ascmd is two new features. The first is the ability to execute custom XMLA requests. Using this feature you will be able to execute XMLA Discovers and XMLA Executes. For example, you are able to determine what databases are on an SSAS instance. You are be able to execute statements that change the default properties so the only the data is returned; not the schema and the data. Second, ascmd now detects if the XMLA input stream is a valid XMLA Command or not. If it is not a valid XMLA Command then it assumes that it is an XMLA Statement and it automatically html encode the input and wraps a <Statement>...</Statement> element around it. This allows you to enter simpler input files when entering MDX queries and DMX statements. See the ascmd readme for more information.

ASTrace

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

ASUV

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

AMOAdventureWorks

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

AMOBrowser

The AMOBrowser sample lets you use AMO objects to connect to a Microsoft SQL Server 2005 Analysis Services (SSAS) server and then browse different AMO objects and their properties.

AS Simple Sample (AMO)

AS Sample은 복잡한 OLAP 큐브를 만들고 새로 만들어진 큐브의 내용에 접근하기 위해 ADOMD.NET을 사용하기 위한 Analysis Management Objects(AMO)의 용도를 설명하는 C# 프로그램입니다.

Backup and Restore

The Backup and Restore sample lets you use AMO objects to connect to a Microsoft SQL Server 2005 Analysis Services (SSAS) server. You can then complete a backup of the Analysis Services database, restore the backup, or delete the backup.

Data Mining Web Controls

Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server 2005 Analysis Services (SSAS) to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed.

Data Mining Plug-in Algorithms

This tutorial steps you through the process of implementing a plug-in algorithm and integrating that algorithm into Analysis Services.

Display Objects Name

Display Objects Name 샘플은 사용자가  AS2005에 연결하기 위하여 AMS Objects를 사용하도록 합니다.  그리고 AMO objects의 이름을 보여줍니다.