Note |
|---|
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. |

See Also