With Set [Kids] AS
'{[Product].[All Products].Children}'
SELECT {[Kids]} ON COLUMNS ,
{ [Unit Sales] } ON ROWS 
FROM [Sales_MDX1] 

SELECT {[Product].[All Products].Children} ON COLUMNS ,
{ [Unit Sales] } ON ROWS 
FROM [Sales_MDX1]

SELECT 
{ [Time].[1997].CHILDREN } ON COLUMNS , 
{[Product].[All Products].Children} ON ROWS  
FROM [Sales_MDX1] 
WHERE ( [Measures].[Unit Sales] )

SELECT
{ [Time].[1997].Children } ON COLUMNS , 
CROSSJOIN ({ [Store].[Store Country].[USA].Children } , {[Product].[All Products].Children}) ON ROWS  
FROM [Sales_MDX1] 
WHERE ( [Measures].[Unit Sales] )

SELECT 
{ [Time].[1997].Children } ON COLUMNS , 
{{ [Store].[Store Country].[USA].Children } * {[Product].[All Products].Children}} ON ROWS  
FROM [Sales_MDX1] 
WHERE ( [Measures].[Unit Sales] )

SELECT
CROSSJOIN ({ [Store].[Store Country].[USA].Children } , {[Product].[All Products].Children}) ON COLUMNS ,
{ [Time].[1997].Children } ON ROWS 
FROM [Sales_MDX1] 
WHERE ( [Measures].[Unit Sales] )

SELECT
CROSSJOIN ({ [Store].[Store Country].[USA].Children } , {[Product].[All Products].Children}) ON COLUMNS ,
CROSSJOIN({ [Time].[1997].Children },{[Customers].[USA].Children}) ON ROWS 
FROM [Sales_MDX1] 
WHERE ( [Measures].[Unit Sales] )

SELECT 
{[Customers].[All Customers].Children} ON COLUMNS,
{[Product].[All Products].Children} ON ROWS
FROM [Sales_MDX1]

SELECT 
NON EMPTY {[Customers].[All Customers].Children} ON COLUMNS,
{[Product].[All Products].Children} ON ROWS
FROM [Sales_MDX1]

SELECT 
{[Customers].[All Customers].Children} ON COLUMNS,
NON EMPTY {[Product].[All Products].Children} ON ROWS
FROM [Sales_MDX1]

SELECT 
NON EMPTY {[Customers].[All Customers].Children} ON COLUMNS,
NON EMPTY {[Product].[All Products].Children} ON ROWS
FROM [Sales_MDX1]

SELECT 
 {[Customers].[All Customers].Children} ON COLUMNS,
 {[Store].[All Stores].Children} ON ROWS
FROM [Sales_MDX1]

SELECT 
NON EMPTY  {[Customers].[All Customers].Children} ON COLUMNS,
NON EMPTY  {[Store].[All Stores].Children} ON ROWS
FROM [Sales_MDX1]

SELECT
{[Product].[Product Family].[Food].CHILDREN} ON COLUMNS
FROM [Sales_MDX1]
WHERE [Measures].[Unit Sales]

SELECT
{TOPCOUNT( [Product].[Product Family].[Food].CHILDREN,4,[Measures].[Unit Sales])} ON COLUMNS
FROM [Sales_MDX1]

SELECT
{TOPCOUNT( [Product].[Product Family].[Food].CHILDREN,5,[Measures].[Unit Sales])} ON COLUMNS
FROM [Sales_MDX1]

SELECT
{TOPCOUNT( [Product].[Product Family].[Food].CHILDREN,5,[Measures].[Unit Sales])} ON COLUMNS
FROM [Sales_MDX1]
WHERE ([Store].[Store Country].[USA].[OR])

SELECT
{TOPCOUNT( [Product].[Product Family].[Food].CHILDREN,5,[Measures].[Unit Sales])} ON COLUMNS,
{[Store].[Store Country].[USA].[OR]} ON ROWS
FROM [Sales_MDX1]

SELECT
{TOPCOUNT( [Product].[Product Family].[Food].CHILDREN,4,[Measures].[Unit Sales])} ON COLUMNS,
{[Store].[Store Country].[USA].[OR]} ON ROWS
FROM [Sales_MDX1]

SELECT 
{[Time].[1997].[Q1]} ON COLUMNS 
FROM [Sales_MDX1] 
WHERE ( [Measures].[Unit Sales] )

SELECT 
{[Measures].[Unit Sales] }ON COLUMNS 
FROM [Sales_MDX1] 
WHERE ([Time].[1997].[Q1]) 

SELECT
{BOTTOMCOUNT( [Product].[Product Family].[Food].CHILDREN,2,[Measures].[Unit Sales])} ON COLUMNS,
{[Store].[Store Country].[USA].Children} ON ROWS
FROM [Sales_MDX1]

SELECT
{BOTTOMCOUNT( [Product].[Product Family].[Food].CHILDREN,2,[Measures].[Unit Sales])} ON COLUMNS,
{[Store].[Store Country].[USA].Children} ON ROWS
FROM [Sales_MDX1]
WHERE ([Customers].[State Province].[OR])

SELECT 
{[Customers].[All Customers].[USA].Children} ON COLUMNS,
{[Product].[All Products].Children} ON ROWS,
{[Time].[1998].Children} ON PAGES
FROM [Sales_MDX1] 

SELECT 
{[Customers].[All Customers].[USA].Children} ON COLUMNS,
{[Product].[All Products].Children} ON ROWS,
{[Time].[1998].Children} ON PAGES,
{[Store],[USA].Children} ON SECTIONS
FROM [Sales_MDX1]

SELECT 
{[Customers].[All Customers].[USA].Children} ON COLUMNS,
{[Product].[All Products].Children} ON ROWS,
{[Time].[1998].Children} ON PAGES,
{[Store],[USA].Children} ON SECTIONS,{[Measures].Members} ON CHAPTERS
FROM [Sales_MDX1]

SELECT 
{[Customers].[All Customers].[USA].Children} ON AXIS(0),
{[Product].[All Products].Children} ON AXIS(1),
{[Time].[1998].Children} ON AXIS(2),
{[Store],[USA].Children} ON AXIS(3),
{[Measures].Members} ON AXIS(4)
FROM [Sales_MDX1]

SELECT 
{[Customers].[All Customers].[USA].Children} ON 0,
{[Product].[All Products].Children} ON 1,
{[Time].[1998].Children} ON 2,
{[Store],[USA].Children} ON 3,
{[Measures].Members} ON 4
FROM [Sales_MDX1]

SELECT
{[Customers].[All Customers].[USA].Children} ON AXIS(0),
{[Product].[All Products].Children} ON AXIS(1),
{[Time].[1998].Children} ON 2,
{[Store],[USA].Children} ON SECTIONS,
{[Measures].Members} ON AXIS(4)
FROM [Sales_MDX1]