Returns all members including calculated ones of [Measures] dimension.
Query
WITH
MEMBER [Measures].[V] AS 42
SELECT
[Measures].AllMembers ON 0
FROM
[Sales]
Result
| Amount |
Amount-Min |
Amount-Max |
Amount-Count |
Amount-AvgChildren |
Amount-None |
Amount-Open |
Amount-Close |
Amount-OpenNoEmpty |
Amount-CloseNoEmpty |
Amount-AvgLeaves |
Amount-NoEmpty |
Amount-Unique |
Fx |
Answer |
V |
| 1023 |
1.00€ |
512.00€ |
10 |
102.3 |
|
|
|
1 |
512 |
102.3 |
1 |
10 |
1.0310000000000001 |
42 |
42 |
Assertion : MDX Equals
WITH
MEMBER [Measures].[V] AS 42
SELECT
Union( [Measures].Members, [Measures].[Answer] /* defined at cube level */ , [Measures].[V] ) ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Measures].[V] AS 42
SELECT
AddCalculatedMembers( [Measures].Members ) ON 0
FROM
[Sales]
Returns all members of the level including calculated members.
In our example all cities including [Basel].
Query
WITH
MEMBER [Geography].[Geo].[Neverland] AS 41
MEMBER [Geography].[Geo].[Switzerland].[Basel] AS 42
SELECT
[Geography].[Geo].[City].AllMembers ON 0
FROM
[Sales]
Result
| Quebec |
Toronto |
Mexico |
Los Angeles |
New York |
San Francisco |
Caracas |
Paris |
Barcelona |
Madrid |
Valencia |
Geneva |
Lausanne |
Zurich |
Basel |
|
|
|
|
768 |
|
|
4 |
2 |
1 |
|
128 |
56 |
64 |
42 |
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[Switzerland].[Basel] AS 42
SELECT
Hierarchize( Union( [Geography].[Geo].[City].members, [Geography].[Geo].[Switzerland].[Basel] )) ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[Switzerland].[Basel] AS 42
SELECT
Hierarchize( AddCalculatedMembers( [Geography].[Geo].[City].members )) ON 0
FROM
[Sales]
Returns all members of the hierarchy including calculated members.
Query
WITH
MEMBER [Geography].[Geo].[Switzerland].[Basel] AS 42
SELECT
[Geography].[Geo].AllMembers ON 0
FROM
[Sales]
Result
| All Regions |
America |
Canada |
Quebec |
Toronto |
Mexico |
Mexico |
United States |
Los Angeles |
New York |
San Francisco |
Venezuela |
Caracas |
Europe |
France |
Paris |
Spain |
Barcelona |
Madrid |
Valencia |
Switzerland |
Geneva |
Lausanne |
Zurich |
Basel |
| 1023 |
768 |
|
|
|
|
|
768 |
|
768 |
|
|
|
255 |
4 |
4 |
3 |
2 |
1 |
|
248 |
128 |
56 |
64 |
42 |
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[Switzerland].[Basel] AS 42
SELECT
Hierarchize( Union( [Geography].[Geo].members, [Geography].[Geo].[Switzerland].[Basel] )) ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[Switzerland].[Basel] AS 42
SELECT
Hierarchize( AddCalculatedMembers( [Geography].[Geo].members )) ON 0
FROM
[Sales]