SQL Server Setup Help | |
Deprecated Analysis Services Functionality in SQL Server 2008 | |
See Also |
Upgrading to SQL Server 2008 > Backward Compatibility > SQL Server Analysis Services Backward Compatibility > |
This topic describes the deprecated Analysis Services features that are still available in SQL Server 2008. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.
Deprecated Features
Category | Deprecated Feature | Comments |
---|---|---|
Connection string properties |
InsertInto |
Original connection string syntax for populating local cubes. |
Connection string properties |
CreateCube |
Original connection string syntax for populating local cubes. Not supported in ADOMD.NET. |
Features |
SQL Server 2000 PMML |
This feature has been replaced with standard Predictive Model Markup Language (PMML). |
Multidimensional Expressions (MDX) |
Create Action |
Extended syntax is supported, but English statements cannot create new types of actions. DDL should be used instead. |
MDX |
CalculationPassValue |
|
MDX |
CalculationCurrentPass |
|
MDX |
NON_EMPTY_BEHAVIOR query optimizer hint was turned on by default |
The NON_EMPTY_BEHAVIOR query optimizer hint will be turned off by default in a future release. It is an MDX optimization hint that can produce incorrect results when it is not used correctly.. |
Other |
CELL_EVALUATION_LIST intrinsic cell property |
Blank in SQL Server Analysis Services. |
Objects |
COM assemblies |
COM assemblies might pose a security risk. |