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

Symptoms

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)}

Cause

This issue occurs because scoped calculations may not be applied for an arbitrary shape set in subselects in certain conditions.

Resolution

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

Workaround

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

ID článku: 3107431 – Posledná kontrola: 14. 2. 2017 – Revízia: 1

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

Pripomienky