Analysis Manager

Microsoft® SQL Server™ 2000 Analysis Services includes Analysis Manager, a console application that provides a user interface for accessing Analysis servers and their meta data repositories. Use Analysis Manager to:

• Administer Analysis servers. Multiple users can administer an Analysis server using Analysis Manager. Locking is applied only to the objects being edited and their dependent objects.
  
  
• Create databases and specify data sources.
  
  
• Build and process cubes.
  
  
• Create and process data mining models.
  
  
• Specify storage options and optimize query performance.
  
  
• Manage security.
  
  
• Browse data sources, shared dimensions, security roles, and other objects.
  
  
• Find links for third-party client applications, support resources, Help updates, and product news.
  
  
• Work through the Analysis Manager tutorial. This step-by-step tutorial guides you through building, deploying, managing, and enhancing an OLAP cube. This tutorial also provides instruction on how to create a data mining model.
  
  
• Obtain information about the complete SQL Server 2000 product.

In addition to the tutorial, the HTML (that is, right) pane of Analysis Manager assists you in learning the concepts and terminology of online analytical processing (OLAP) and data mining, as well as how to store and manage the associated data.