The fix also applies to Microsoft SQL Server 2014 Analysis Services (SSAS 2014).
Symptoms
Consider the following scenario:
- You run a Multidimensional Expressions (MDX) query in an instance of Microsoft SQL Server 2012 Analysis Services (SSAS 2012) or SQL Server 2014 Analysis Services (SSAS 2014). SSAS 2012 or SSAS 2014 is running in tabular mode.
- The query contains more than three GROUP BY clauses.
- You try to cancel the query.
In this scenario, it may take longer than expected for the query to stop running. Additionally, you may be unable to process data in SSAS 2012 or SSAS 2014, create new connections, or run other queries while the original query is still running.
Resolution
After you apply this hotfix, the time that is required to cancel a query is reduced. Additionally, this hotfix improves the performance of SSAS 2012 or SSAS 2014.
The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 1 for SQL Server 2014 /en-us/help/2931693
Cumulative update 6 for SQL Server 2012 SP1 /en-us/help/2874879
About cumulative updates for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.