Discontinued Analysis Services Functionality in SQL Server 2005

SQL Server Setup

The following features that existed in Microsoft SQL Server 2000 Analysis Services have been removed from Microsoft SQL Server 2005 Analysis Services (SSAS).

Discontinued Features

Category Discontinued Feature Comments

Connection string properties

Mining Execution Location

Accepted for backward compatibility, but is ignored. Execution is always on the server.

Connection string properties

Mining Location

 

Connection string properties

Log File

The Log File feature is replaced by the Trace feature.

Connection string properties

Execution Location

 

Connection string properties

Distinct Measures by Key

 

Connection string properties

Large Level Threshold

 

Features

Aggregated Providers

This feature is replaced by plug-in algorithms.

Features

Linked Cubes

This feature is replaced by linked measure groups.

Features

Custom Level Formulas

This feature is replaced by Multidimensional Expressions (MDX) scripts.

Features

Cube and Database Role Commands

No longer supported.

MDX

CreateVirtualDimension

This MDX function is no longer supported.

MDX

CreatePropertySet

This MDX function is no longer supported.

MDX

Ignore

In SQL Server 2000 Analysis Services, this function was reserved for future use.

MDX

With Cache

Create Cache

Accepted but is not supported.

Other

Active Directory Registration

 

Other

Skipped levels in parent-child hierarchies

The SkippedLevelsColumnproperty, which indicates how many levels to skip when creating a member under a parent in a parent-child hierarchy, is no longer supported.

See Also