Members are considered as tuples with a single member.
Query
WITH
MEMBER [Measures].[XX] AS [Measures].defaultMember.value
SELECT
[Measures].[XX] ON 0,
[Geography].[Geo].[Country].members on 1
FROM
[Sales]
Result
|
XX |
| Canada |
|
| Mexico |
|
| United States |
768 |
| Venezuela |
|
| France |
4 |
| Spain |
3 |
| Switzerland |
248 |
Assertion : Cell Equals
WITH
MEMBER [Measures].[XX] AS [Measures].defaultMember
SELECT
[Measures].[XX] ON 0,
[Geography].[Geo].[Country].members on 1
FROM
[Sales]
Value of the tuple is returned.
Query
WITH
MEMBER [Measures].[XX] AS ( [Time].[Calendar].[2010], [Measures].defaultMember ).value
SELECT
[Measures].[XX] ON 0,
[Geography].[Geo].[Country].members on 1
FROM
[Sales]
Result
|
XX |
| Canada |
|
| Mexico |
|
| United States |
768 |
| Venezuela |
|
| France |
4 |
| Spain |
3 |
| Switzerland |
248 |
Assertion : Cell Equals
WITH
MEMBER [Measures].[XX] AS ( [Time].[Calendar].[2010], [Measures].defaultMember )
SELECT
[Measures].[XX] ON 0,
[Geography].[Geo].[Country].members on 1
FROM
[Sales]