Query only Dimension Data

We Have a case where we have to create a report only with the dimension data from SSAS.
Is there any way in doing it in Excel 2007.

I see a pivot table option which says " Display item labels when no fields are in the value area"
but this is disabled. Can anyone point me to a way of doin this or enabling this.

Thankyou
VidyaAre you creating the report through excel or programmatically? If programmatically $Dimension exposes the dimension as a cube and you can use it as you would any cube...