Evaluates the sum of the neutral element with a set
Query
SELECT
∅ + {[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Evaluates the product of the neutral element with a set
Query
SELECT
∅ * {[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
SELECT
crossjoin( ∅, {[Geography].[Economy].[Switzerland]} ) ON 0
FROM
[Sales]
Assertion : MDX Equals
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Adding the neutral element to a tuple has no effect
Query
SELECT
{(∅,[Geography].[Economy].[Switzerland])} ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Using the Neutral element in a where clause
Query
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
WHERE ∅
Result
Assertion : MDX Equals
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Using the Neutral element in a subselect
Query
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
( select ∅ on 0 from [Sales] )
Result
Assertion : MDX Equals
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Assertion : Cell Equals
SELECT
[Geography].[Economy].defaultMember ON 0
FROM
( select ∅ on 0, {[Geography].[Economy].[Switzerland]} ON 1 from [Sales] )
Using the Neutral element in a filterBy
Query
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
FILTERBY ∅
Result
Assertion : MDX Equals
SELECT
{[Geography].[Economy].[Switzerland]} ON 0
FROM
[Sales]
Assertion : MDX Equals
SELECT
∅ * {∅ + {(∅,[Geography].[Economy].[Switzerland],∅,∅)}} ON 0
FROM
(SELECT ∅ ON 0 FROM [Sales])
WHERE ∅
FILTERBY ∅
Using the Neutral element with Union, Intersection, Except and Distinct
Query
WITH
MEMBER Union1 as Union( ∅, {[Geography].[Economy].[Switzerland]} ) is {[Geography].[Economy].[Switzerland]}
MEMBER Union2 as Union( {[Geography].[Economy].[Switzerland]}, ∅ ) is {[Geography].[Economy].[Switzerland]}
MEMBER Union3 as Union( ∅, ∅ ) is ∅
MEMBER Intersect1 as Intersect( ∅, {[Geography].[Economy].[Switzerland]} ) is {[Geography].[Economy].[Switzerland]}
MEMBER Intersect2 as Intersect( {[Geography].[Economy].[Switzerland]}, ∅ ) is {[Geography].[Economy].[Switzerland]}
MEMBER Intersect3 as Intersect( ∅, ∅ ) is ∅
MEMBER Except1 as Except( {[Geography].[Economy].[Switzerland]}, ∅ ) is {[Geography].[Economy].[Switzerland]}
MEMBER Except2 as Except( ∅,{[Geography].[Economy].[Switzerland]} ) is ∅
MEMBER Except3 as Except( ∅, ∅ ) is ∅
MEMBER Distinct1 as Distinct( ∅ ) is ∅
SELECT
{Union1,Union2,Union3,Intersect1,Intersect2,Intersect3,Except1,Except2,Except3,Distinct1} ON 0
FROM
[Sales]
Result
Union1 |
Union2 |
Union3 |
Intersect1 |
Intersect2 |
Intersect3 |
Except1 |
Except2 |
Except3 |
Distinct1 |
true |
true |
true |
true |
true |
true |
true |
true |
true |
true |
Assertion : MDX Equals
WITH
MEMBER Union1 as true
MEMBER Union2 as true
MEMBER Union3 as true
MEMBER Intersect1 as true
MEMBER Intersect2 as true
MEMBER Intersect3 as true
MEMBER Except1 as true
MEMBER Except2 as true
MEMBER Except3 as true
MEMBER Distinct1 as true
SELECT
{Union1,Union2,Union3,Intersect1,Intersect2,Intersect3,Except1,Except2,Except3,Distinct1} ON 0
FROM
[Sales]
You can test if an MDX entity is the neutral element with isNeutral function or is.
Query
WITH
MEMBER test as isNeutral(∅)
SELECT
test ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER test as true
SELECT
test ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER test as ∅ is ∅
SELECT
test ON 0
FROM
[Sales]
You can use NeutralElement function to return the neutral element
Query
WITH
MEMBER test as ∅ is NeutralElement()
SELECT
test ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER test as true
SELECT
test ON 0
FROM
[Sales]
Assertion : MDX Equals
WITH
MEMBER test as ∅ is ∅
SELECT
test ON 0
FROM
[Sales]