FIX: Arbitrary shape multi-select query ignores scoped calculations and returns unexpected results in SSAS

Consider the following scenario:
  • You create a Multidimensional Expressions (MDX) script that contains custom calculations for a cube in Microsoft SQL Server Analysis Services (SSAS).
  • You connect to the instance of Analysis Services from a client application. For example, you connect from Microsoft Excel.
  • You create an MDX query that contains subselect expressions in the client application. To do this, you use multi-select filtering, for example.
  • The hierarchy elements of the dimensions form an arbitrary shape set.
In this scenario, the MDX query (and the report that's based on it) return unexpected results.

Note An arbitrary shape set is a set that cannot be easily expressed as a crossjoin set of two sets of attribute members. An example of an arbitrary shape set is the following:

{(2004, USA), (2001, Canada)}
This issue occurs because scoped calculations may not be applied for an arbitrary shape set in subselects in certain conditions.

Cumulative Update information

The issue was first fixed in the following cumulative update of SQL Server.

Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included in the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:

To work around this issue, change the MDX query so that it does not use an arbitrary shape set in the filter selections.

Article ID: 3107431 - Last Review: 01/18/2016 02:44:00 - Revision: 1.0

Microsoft SQL Server 2014 Service Pack 1, Microsoft SQL Server 2014 Business Intelligence

  • kbqfe kbsurveynew kbexpertiseadvanced kbfix KB3107431