MDX queries differs from SQL queries in many aspects...
MSDN wrote:
Important
Unlike the WHERE
clause in SQL, the WHERE
clause of an MDX SELECT
statement never directly filters what is returned on the Rows axis of a query. To filter what appears on the Rows or Columns axis of a query, you can use a variety of MDX functions, for example FILTER
, NONEMPTY
and TOPCOUNT
.
Source:
The Basic MDX Query (MDX)[
^] and
Specifying the Contents of a Slicer Axis (MDX)[
^]
Few interesting information you'll find here:
SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy[
^]
I'm not familiar with MDX queries, but try this
WHERE
statement:
WHERE ({[Measures].[Row number].[10], [Measures].[Row number].[11], ..., [Measures].[Row number].[15]})