The set is evaluated taking into account the slicer definition.
In our example, [Cities] set is filtering all [Economy] countries using the slicer [Switzerland]
Query
WITH
SET [Cities] AS EXISTING [Geography].[Economy].[Country].members
SELECT
[Cities] ON 0
FROM
[Sales]
WHERE
[Geography].[Geo].[Switzerland]
Result
Assertion : MDX Equals
WITH
SET [Cities] AS {[Geography].[Economy].[Switzerland]}
SELECT
[Cities] ON 0
FROM
[Sales]
The set is evaluated taking into account the slicer definition.
Our example is counting the number of cities for the country defined in the slicer (i.e., Switzerland).
Query
WITH MEMBER [City Count] AS Count( EXISTING [Geography].[Geo].[City].members )
SELECT
[City Count] ON 0
FROM
[Sales]
WHERE
[Geography].[Geo].[Switzerland]
Result
Assertion : MDX Equals
WITH MEMBER [City Count] AS Count( [Geography].[Geo].[Switzerland].children )
SELECT
[City Count] ON 0
FROM
[Sales]
The set is evaluated taking into account the slicer definition.
Our example is counting the number of cities for the country defined in the sub-query (i.e., Switzerland).
Query
WITH MEMBER [City Count] AS Count( EXISTING [Geography].[Geo].[City].members )
SELECT
[City Count] ON 0
FROM
( SELECT [Geography].[Geo].[Switzerland] ON 0 FROM [Sales] )
Result
Assertion : MDX Equals
WITH MEMBER [City Count] AS Count( [Geography].[Geo].[Switzerland].children )
SELECT
[City Count] ON 0
FROM
[Sales]
The set is evaluated taking into account the slicer definition.
Our example is counting the number of cities for the country defined in the axis (i.e., Switzerland).
Query
WITH MEMBER [City Count] AS Count( EXISTING [Geography].[Geo].[City].members )
SELECT
[City Count] ON 0, [Geography].[Geo].[Switzerland] ON 1
FROM
[Sales]
Result
Assertion : MDX Equals
WITH MEMBER [City Count] AS Count( [Geography].[Geo].currentMember.children )
SELECT
[City Count] ON 0, [Geography].[Geo].[Switzerland] ON 1
FROM
[Sales]