MDX Queries - Misc

I have always find it difficult to have some examples ready to query using MDX. Here are some examples and will be adding more:

To get the leaf level members:

SELECT 

             {[Time].levels(0).members} 

ON ROWS

To get all members of one dimension:

SELECT 

             {[Time].members} 

ON ROWS

To get asymmetric columns:

SELECT {

([Dim1 Member1],[ Dim2 Member1]),

([Dim1 Member2], Dim2 Member2)

} ON COLUMNS

MDX Query - Count Level Zero Members

In one of our implementation I wanted to know the number of level zero members in a dimension and after some research finally ended up having following MDX query:

WITH

Member [Product].[ProCount] AS 'Count([Product].Levels(0).members)'

SELECT {[Year]} on AXIS(0),

{[Product].[ProCount]} on Axis(1)

FROM [Sample.Basic];