Breaking Changes to Analysis Services Features in SQL Server 2014


This topic describes breaking changes in SQL Server 2014 Analysis Services (SSAS). These changes might break applications, scripts, or functionality based on earlier versions of SQL Server.

In this topic:

There are no new breaking changes announced for tabular, multidimensional, data mining, or PowerPivot for SharePoint features in this release. However, because SQL Server 2014 Analysis Services (SSAS) is so similar to the SQL Server 2012 and SQL Server 2012 SP1 versions, breaking changes from both prior releases are provided here as a convenience in case you're upgrading from SQL Server 2008.

Globalization-related code changes have been known to break some applications. Known issues include:

Case-sensitivity of object identifiers
A code change intended to make all object identifiers case-insensitive is having the opposite effect for some languages. The intention is that all object identifiers will be case-insensitive, regardless of collation. This change aligns Analysis Services with other applications typically used in the same solution stack.

For languages based on the 26 characters of the basic Latin alphabet, object identifiers are now case insensitive, which is the intended behavior.

For Cyrillic and other bicameral language scripts that use casing (Greek, Armenian, and Coptic), object identifiers are now case-sensitive. Breaking changes are most likely to occur when there is case difference between an object identifier and how it is referenced (for example, a processing script that refers to the object identifier in all lower-case). This behavior is likely to change in the future, but as a temporary workaround, we suggest modifying scripts to use the same case as the object identifier.

This section documents the breaking changes reported for Analysis Services features in SQL Server 2012.

Setup commands removed for a PowerPivot for SharePoint installation.Setup installs, but no longer configures, a PowerPivot for SharePoint. Setup commands that collected values used for configuration actions are now removed. These include /FARMACCOUNT, /FARMPASSWORD, /PASSPHRASE, and /FARMADMINPORT.

If you created installation scripts for unattended setup, you will need to modify those scripts for a PowerPivot for SharePoint installation. The alternative is to use PowerShell cmdlets to configure the server in unattended mode. For more information, see Install PowerPivot from the Command Prompt and PowerPivot Configuration using Windows PowerShell.

This section contains the breaking changes from previous releases. If you are upgrading from SQL Server 2005, you should review the breaking changes that were introduced in SQL Server 2008 and SQL Server 2008 R2.

The shallow exists function now works differently with named sets that contain enumerated members or crossjoins of enumsets.In SQL Server 2005 Analysis Services (SSAS), the shallow exists function did not work with named sets that contained enumerated members or crossjoins of enumsets. For backward compatibility with the original release version and SP1 of SQL Server 2005 Analysis Services (SSAS), set the configuration property "ConfigurationSettings\OLAP\Query\NamedSetShallowExistsMode" to 1, or for backward compatibility with SQL Server 2005 Analysis Services (SSAS) SP2, set it to 2.
VBA functions handle null values and empty values differently than they were handled in SQL Server 2005 Analysis Services (SSAS)In SQL Server 2005 Analysis Services (SSAS), VBA functions returned 0 or an empty string when either null values or empty values were used as arguments. In SQL Server 2008, they will return null.
The Migration Wizard will fail because DSO is not installed by Default.By default, SQL Server 2008 does not install the DSO (Decision Support Objects) backward compatibility component. The backward compatibility package is installed by default but the DSO component of the package will be disabled. Since the SQL Server Analysis Services Migration Wizard relies on this component, it will fail unless the component is installed. To install the DSO component, do the following:

1) Open Control Panel.
2) In Windows XP or Windows Server 2003, select Add or Remove Programs. In Windows Vista and Windows Server 2008, select Programs and Features.
3) Right-click Microsoft SQL Server 2005 Backward Compatibility, and select Change.
4) In the Backward Compatibility Setup wizard, click Next.
5) On the Program Maintenance page, select Modify, and then click Next.
6) On the Feature Selection page, if Decision Support Objects (DSO) is not available, click the down arrow and select This feature will be installed on local hard drive. Click Next.
7) On the Ready to Modify the Program page, click Install.
8) When installation is finished, click Finish.


You can remove DSO after migration is complete by following the previous steps, changing the option for DSO to “This feature will not be available.”

If the backward compatibility package is not installed, you can install it from the SQL Server 2008 distribution media. Note that there are versions for each target architecture (x86, x64, ia64). These versions can be found at the following locations:



It is not recommended to put the partition location in the Data folder.The server manages the Data folder and creates or drops folders as objects are created, deleted, and altered. Therefore, specifying a partition storage location inside the Data folder is strongly discouraged, especially in the subfolders for databases, cubes, and dimensions. Although the server allows you to do this with Create or Alter, it will display a warning. When you upgrade databases from SQL Server 2005 Analysis Services to SQL Server 2008 Analysis Services that have partition storage locations in the Data folder, it will work. Restore or Sync will require that you move partition storage locations outside the Data folder.
You might get unexpected results for queries that use the "EXISTING" MDX keyword in ProClarity Analytics Server and Microsoft Office PerformancePoint Server 2007.ProClarity Analytics Server and Microsoft Office PerformancePoint Server 2007 use the EXISTING keyword in MDX incorrectly in certain scenarios. Due to changes made in SQL Server 2008 Analysis Services, these queries might return unexpected results.

Analysis Services Backward Compatibility