Deprecated Analysis Services Functionality in SQL Server 2008

SQL Server Setup

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