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
