Returns all [Measures] members including calculated ones (which are siblings).
Query
WITH
MEMBER [Measures].[V] AS 42
SELECT
AddCalculatedMembers( [Measures].Members ) 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 |
512 |
10 |
102.3 |
|
|
|
1 |
512 |
102.3 |
1 |
10 |
1.0310000000000001 |
42 |
42 |
Assertion : MDX Equals
WITH
MEMBER [Measures].[V] AS 42
SELECT
[Measures].Members + { [Measures].[Answer] /* defined at cube level */ , [Measures].[V] } ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER [Measures].[V] AS 42
SELECT
[Measures].AllMembers ON 0
FROM
[Sales]
Returns members-set with all calculated members which are siblings of 'members-set'.
We create a new city in the United States as a calculated member : [Austin]
We create a new city in Spain as a calculated member : [Sevilla]
AddCalculatedMembers to the United States cities adds the calculated member [Austin] as it's a sibling. [Sevilla] is not added as it's not a city of the United States.
Query
WITH
MEMBER [Geography].[Geo].[America].[United States].[Austin] AS 1
MEMBER [Geography].[Geo].[Europe].[Spain].[Sevilla] AS 2
SELECT
AddCalculatedMembers( { [Geography].[Geo].[America].[United States].Children, [Geography].[Geo].[Europe].[France].[Paris] } ) ON 0
FROM
[Sales]
Result
| Los Angeles |
New York |
San Francisco |
Austin |
Paris |
|
768 |
|
1 |
4 |
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[America].[United States].[Austin] AS 1
SELECT
{ [Geography].[Geo].[America].[United States].Children, [Geography].[Geo].[America].[United States].[Austin], [Geography].[Geo].[Europe].[France].[Paris] } ON 0
FROM
[Sales]