WHERE { ([Time].[1st half], [Route].[nonground]), ([Time].[1st half], [Route].[ground]) }

-- Query 0
select 
{
	[Product].[Product Categories].[All], 
	[Product].[Product Categories].[All].children
} on  0 ,

crossjoin(
	{
		[Customer].[Customer Geography].[All Customers], 
		[Customer].[Customer Geography].[All Customers].children
	}, 
	{
		[Measures].[Internet Sales Amount], 
		[Measures].[Internet Order Count]
	}
) on  1 
from [Direct Sales]


-- Query 1
with 
set set1 as 
{
	(
		[Product].[Product Categories].[Category].&[ 3 ], 
		[Customer].[Customer Geography].[All Customers]
	),
	(
		[Product].[Product Categories].[All], 
		[Customer].[Customer Geography].[Country-Region].&[Australia])
}
-- Двойной учет
--member [Product].[Product Categories].[MyMember] as AGGREGATE(set1, [Measures].currentmember)  

-- А так правильно
member [Product].[Product Categories].[MyMember] as 
 AGGREGATE(set1, [Measures].currentmember) - 
 ([Product].[Product Categories].[Category].&[ 3 ], 
  [Customer].[Customer Geography].[Country-Region].&[Australia], [Measures].currentmember)

select 
{[Measures].[Internet Sales Amount], [Measures].[Internet Order Count]} on  0 
from [Direct Sales]
where [Product].[Product Categories].[MyMember]

-- Query 2 (ни поведение ни результат не понятен, короче не то что хотелось :-(
select 
{[Measures].[Internet Sales Amount], [Measures].[Internet Order Count]} on  0 
from [Direct Sales]
where
{
	(
		[Product].[Product Categories].[Category].&[ 3 ], 
		[Customer].[Customer Geography].[All Customers]
	),
	(
		[Product].[Product Categories].[All], 
		[Customer].[Customer Geography].[Country-Region].&[Australia])
}