FIX: SSAS crashes when you execute an MDX query that refers to a calculated member which is a child member of another hierarchy

Applies to: SQL Server 2014 DeveloperSQL Server 2014 EnterpriseSQL Server 2014 Enterprise Core More

Symptoms


Assume that you use Microsoft SQL Server 2014, SQL Server 2016, or SQL Server 2017 Analysis Services (SSAS). When you run a Multidimensional Expressions (MDX) query that refers to a calculated member, and when the referenced calculated member is a child member of another hierarchy in SQL Server, SSAS may crash.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 1 for SQL Server 2017

       Cumulative Update 8 for SQL Server 2016 RTM

       Cumulative Update 5 for SQL Server 2016 SP1

       Cumulative Update 6 for SQL Server 2014 SP2

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.