Deprecated Analysis Services Functionality in SQL Server 2008 R2
 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.
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. |
