I'm new to MDX and Mondrian and have two time related questions:

1.)
The MDX command


Code:
SELECT NON EMPTY {[Country].[Country].Members} ON COLUMNS, [Time].[2012].[Q1 2012].[2].[2012-02-08]:[Time].[2012].[Q4 2012].[11].[2012-11-08] ON ROWS FROM [MyCube] WHERE {[Measures].[Sales]}
prints the result grouped by days:

2012-02-08 | 2873 | 9829 | ...
2012-02-09 | ...

But I want to define the date range in days (like above) and get the result grouped by months:

2012-02 | 34298| ...
2012-03 | ...

2.)


The Mondrian schema documentation lists the time level types TimeYears, TimeQuarters, TimeMonths and TimeDays. Is it possible to define hours too?



Thanks a lot.