







SQL Server Setup Help | |
Discontinued Analysis Services Functionality in SQL Server 2005 | |
![]() |
![]() ![]() |
Upgrading to SQL Server 2005 > Backward Compatibility > SQL Server 2005 Analysis Services Backward Compatibility > |
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. |