Udostępnij za pośrednictwem


Deprecated Analysis Services Functionality in SQL Server 2012

This topic describes the deprecated Analysis Services features that are still available in SQL Server 2012. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

Features Not Supported in the Next Version of SQL Server

The following Analysis Services features will not be supported in the next version of SQL Server. Do not use these features in new development work, and modify applications that currently use these features as soon as possible.

Category

Deprecated feature

Replacement

Local cubes

InsertInto connection string property

Original connection string syntax for populating local cubes is replaced by the Create Global Cube statement. For more information, see CREATE GLOBAL CUBE Statement (MDX).

Local cubes

CreateCube connection string property

Original connection string syntax for populating local cubes is replaced by the Create Global Cube statement. For more information, see CREATE GLOBAL CUBE Statement (MDX).

Data Mining

SQL Server 2000 PMML

The SQL Server 2000 PMML feature produced a form of PMML that had proprietary extensions to support unique features provided by Data Mining algorithms that were not available in the PMML specification. In SQL Server 2005, Analysis Services updated the PMML feature to the newer PMML 2.1 standard. As a result, the proprietary extensions added in SQL Server 2000 are no longer needed, although they are still supported in this release.

MDX Statement

Create Action statement

This statement is included for backwards compatibility. It is replaced by the Action object. For more information about how to create actions in recent versions of Analysis Services, see Actions (Analysis Services - Multidimensional Data).

MDX Statement

Non_empty_behavior proeprty

Avoid setting this property when creating a calculated member. Setting it incorrectly increases the chances of returning invalid results. Furthermore, the property is no longer as useful as it once was. Engine optimizations over the past several releases have improved operations over sparse data sets, making this property less relevant.

Features Not Supported in a Future Version of SQL Server

The following Analysis Services features are supported in the next version of SQL Server, but will be removed in a later version. The specific version of SQL Server has not been determined.

Category

Deprecated feature

Replacement

MDX Function

CalculationPassValue function

None. The OLAP engine manages the calculation pass. This function is no longer needed.

MDX Function

CalculationCurrentPass function

None. The OLAP engine manages the calculation pass. This function is no longer needed.

Multidimensional Expressions (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.

MDX

Non_Empty_Behavior property

None. When creating a calculated member, setting this property incorrectly increases the likelihood of returning invalid results. Recent optimizations to the OLAP engine have improved operations over sparse data sets, making this property less relevant.

Other

CELL_EVALUATION_LIST intrinsic cell property

Originally provided a list of evaluated formulas that apply to a cell. It is blank in this release of Analysis Services. Solve order is now specified in MDX script. For more information, see Understanding Pass Order and Solve Order (MDX)

Objects

COM assemblies

COM assemblies can pose a security risk. Support for COM assemblies will be removed in a future release.

Zobacz także

Koncepcje

Discontinued Analysis Services Functionality in SQL Server 2012

Inne zasoby

Analysis Services Backward Compatibility