Hello:
I have a cube with 3 dimensions and measure.
The dimensions are : "dates", "factors" and "ID".
Could you give me a hint to create a MDX query
to extract ONLY "dates" dimension from the cube, one column like that:

"dates"
----------------
2001-12-01
2002-01-01
2002-02-01
2002-03-01
2002-04-01
.....................


Thanks,
GB

Here's an example from the Foodmart Sales cube:

'[Time].CurrentMember.UniqueName'
select {[Measures].[MonthFullName]} on columns,
Non Empty [Time].[Month].Members on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***