Deprecated Analysis Services Functionality in SQL Server 2008 R2
Notes
For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.
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. |