Other Enhancements
This release of Microsoft® SQL Server™ 2000 Analysis Services incorporates various enhancements to improve usability, processing performance, and MDX functionality.
Multiuser Administration
Multiple users can administer an Analysis server using Analysis Manager. Locking is applied only to the objects being edited and their dependent objects. For more information, see Analysis Manager.
Integration of Add-ins
The Archive and Restore Databases Add-in and the Copy and Paste Objects Add-in originally created for SQL Server version 7.0 OLAP Services are upgraded, installed, and fully integrated in this release. You can now use Analysis Manager to archive and restore SQL Server 2000 Analysis Services databases and to copy and paste objects in the Analysis Manager tree pane. For more information, see Archiving and Restoring Databases and Copying and Pasting Objects.
MDX Enhancements
A number of new functions have been added to the Multidimensional Expressions (MDX) syntax that you can use for calculated members and increased analytical evaluation. For more information, see MDX.
MDX Builder
A new MDX Builder tool helps you create MDX expressions using drag-and-drop techniques. The MDX editing text box has been enhanced to provide color coding of keywords and functions, indication of parentheses balance, and smart tips that show function syntax. For more information, see MDX Builder.
Table Aliases
In Cube Editor and Dimension Editor you can specify table aliases. For more information, see Schema Tab (Cube Editor Schema View) and Schema Tab (Dimension Editor Schema View).
Active Directory Support
Analysis Services supports Active Directory™, the directory service that is included with Microsoft Windows® 2000. You can enable an Analysis server so that it publishes Active Directory entries when the server starts and updates the entries when the server status changes. For more information, see Using Active Directory with Analysis Services.
Performance Monitor Counters
A number of performance counters are now available for Analysis server that can be used with Performance Monitor in Microsoft Windows NT® 4.0 or System Monitor in Windows 2000. For more information, see Monitoring Analysis Services Performance.