Role specifications are enforced on OLAP servers installed on either File Allocation Table (FAT) or NTFS file systems.

Integration of Add-ins

The Archive and Restore Databases add-ins 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 Services Manager to archive and restore Analysis Services databases and to copy and paste objects in the Analysis Services Manager tree pane. For more information, see Archiving and Restoring Databases and Copying and Pasting Objects.

Virtual Cube Editor

A new editor for virtual cubes is similar in function to Cube Editor and replaces and expands the functionality provided by the Calculated Member Manager Add-in for SQL Server version 7.0 OLAP Services. For more information about Virtual Cube Editor, see Virtual Cube Editor.

Linked Cubes

A cube can be stored on a single OLAP server and then defined as a linked cube on other OLAP servers. The cube can then be accessed by end-users connected to any of these OLAP servers. This arrangement avoids the more costly alternative of storing and maintaining copies of a cube on multiple OLAP servers. To end users, a linked cube appears as a regular cube. For more information, see Linked Cubes.

Remote Partitions

You can use remote partitions to distribute a cube's data among multiple OLAP servers and administer the cube on a single OLAP server. For more information, see Remote Partitions.

Drillthrough

Client applications that support drillthrough can now allow end users to select a cube cell and retrieve a result set from the source data for that cell. You can use roles to control user access to the drillthrough functionality. For more information, see Specifying Drillthrough Options.

Distinct Count

You can use the new Distinct Count aggregate function for measures to analyze the number of unique occurrences of events in your data. For more information, see Distinct Count.

MDX Builder

A new MDX Builder dialog box helps you create MDX expressions using drag-and-drop techniques. For more information, see MDX Builder.

Hidden Cube Elements

You can hide dimensions, levels, measures, and member properties from end users who browse cubes with client applications. The visibility of these objects is controlled by the Visible property. For more information, see Properties Pane in Cube Editor and Properties Pane in Dimension Editor.

SQL Server 2000 Preview 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19