List dimension members with MDX query

Question

Is there a way to list dimension members without fetching default Measure for each member?

Answer 1

You could SELECT nothing on the opposite axis:

SELECT
  { } on 0,
  { DESCENDANTS([Dimension].[Hierarchy]) } on 1
FROM [Cube]

SELECTing an empty set prevents SSAS from adding the default measure on the opposite axis.