Hi all.

The first records in my database are from may 2004, now i'm trying to
build a report with the information from 2004, and i want to include
the month's (Jan-April), yes i know there is no data, but is there a
way????


SELECT {[records]} ON AXIS(0),
NON EMPTY { Descendants([XXX].[All
XXX],[Gravidade].[Description],LEAVES) } ON AXIS(1),
NON EMPTY { Descendants([Type].[All Type],[Type].[SubType],LEAVES) }
ON AXIS(2),
NON EMPTY { Descendants([Date].[All Date],[Date].[Month],LEAVES) }
ON AXIS(3),
NON EMPTY { Descendants([State].[All
State],[State].[Description],LEAVES) } ON AXIS(4),

FROM [MyCube]


Thanks in advance!

Ricardo Coelho