Deprecated Analysis Services Features in SQL Server 2014


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

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.

CategoryDeprecated featureReplacement
MDX FunctionCalculationPassValue functionNone. The OLAP engine manages the calculation pass. This function is no longer needed.
MDX FunctionCalculationCurrentPass functionNone. 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.
OtherCELL_EVALUATION_LIST intrinsic cell propertyOriginally 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)
ObjectsCOM assembliesCOM assemblies can pose a security risk. Support for COM assemblies will be removed in a future release.

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.

CategoryDeprecated featureReplacement
Multidimensional modelsRemote partitionsNone. Use local partitions instead. See Create and Manage a Local Partition (Analysis Services) for more information.
Multidimensional modelsRemote linked measure groupsA remote linked measure group is a linked measure group using a data source on a remote server. The ability to use a remote data source for a linked measure group is now scheduled for deprecation.

There is no replacement for this feature. We recommend using local linked measure groups instead. See Linked Measure Groups for more information.
Multidimensional modelsDimensional writebackNone. Use partition writeback if you require writeback capability. See Set Partition Writeback for more information.
Multidimensional modelsLinked dimensionsNone. Consider copying dimensions to additional models rather than linking to a dimension in another model.
MDXNon_Empty_Behavior propertyNone. 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.

Analysis Services Backward Compatibility
Discontinued Analysis Services Functionality in SQL Server 2014