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

This hotfix also applies to Microsoft SQL Server 2014 and 2017 Analysis Services (SSAS), SQL Server 2012 SP2, and SQL Server 2016 SP1.

Symptoms

Consider the following scenario:

  • You create a pivot table by using one measure and several dimension attributes in SQL Server Analysis Services (SSAS).

  • You filter on a specific item, and then you remove the filter from one of the dimensions.

  • In the filter condition, there is a previous query (query 1) that has a sub select, and a subsequent query (query 2) that runs on a perspective.

    Notes

    • Both query 1 and query 2 run under the same role.

    • The space that is sought by query 2 can be satisfied from the space of query 1 (without the sub select slice). There is a calculation on query 1 and also on query 2, and this causes the results to be cached and then searched in the global formula engine cache.

In this scenario, the totals are wrong because they still display the sum of the specific filtered item.

Cause

The problem occurs because of a regression in "Grand Totals" from Cumulative Update 4 for Microsoft SQL Server 2012 SP1.

Resolution

The issue is fixed in the following cumulative updates of SQL Server:

Cumulative Update 10 for SQL Server 2017

Cumulative update 8 for SQL Server 2016 SP1

Cumulative Update 1 for SQL Server 2012 SP2

Cumulative Update 2 for SQL Server 2014

Cumulative Update 10 for SQL Server 2012 SP1

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.

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!

×