Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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:

Internal error: An unexpected exception occurred.

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

About SQL Server builds

Each new build for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:

SQL Server 2017 build versions


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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!