Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 790

DrillDownLevel ({[Customer].[Customer
Geography].[All Customers]}
)
)
},
{[Customer].[Customer
Geography].[Country].&[United Kingdom],
[Customer].[Customer
Geography].[Country].&[Germany],
[Customer].[Customer
Geography].[Country].&[France],
[Customer].[Customer
Geography].[Country].&[Canada],
[Customer].[Customer
Geography].[Country].&[Australia]}
)
)},
{[Customer].[Customer
Geography].[Country].&[United Kingdom],
[Customer].[Customer
Geography].[Country].&[Germany],
[Customer].[Customer
Geography].[Country].&[France],
[Customer].[Customer
Geography].[Country].&[Canada],
[Customer].[Customer
Geography].[Country].&[Australia]}))
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS ,
NON EMPTY HIERARCHIZE (
AddCalculatedMembers ({DrillDownLevel ({
[Date].[Fiscal].[All Periods]})}))
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON ROWS FROM
[Direct Sales]
WHERE ([Measures].[Internet Sales Amount])
In this MDX query the MDX function Except is used to restrict the data to Un-
ited States. The Except function takes two arguments, Set1 and Set2, and
eliminates all the members in Set1 that are found in Set2. In the preceding
example the AddCalculatedMembers function returns the members in the