FIX: “An unexpected exception occurred” in an MDX query for PC dimensions in SSAS 2017

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core


Consider the following scenario:

  • You run an instance of Microsoft SQL Server 2017 Analysis Services (SSAS 2017).

  • You enable translations for your parent-child (PC) dimensions attributes.

  • You run a Multidimensional Expressions (MDX) query that references translated dimension attribute names.

In this scenario, you receive an error message that resembles the following:

This issue also occurs in client queries such as Microsoft Excel, Microsoft SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), and so on.


This problem is fixed in the following update for SQL Server:

Cumulative Update 12 for SQL Server 2017


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


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