Discontinued Analysis Services Functionality in SQL Server 2005
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
Concepts
Migrating Existing Analysis Services Databases
Other Resources
SQL Server 2005 Analysis Services Backward Compatibility