I'm trying to create a MDX query excluding the Quarter and grabbing
the month only in that year.

Current example Query...

Select
{[Ship Date].[All Ship Date].&[2003].Children}on Columns,
NON Empty {[Measures].[Load Count], [Measures].[Invoice Amount],
[Measures].[Weight],[Measures].[Miles] } on Rows
FROM
Customer

What I would like to get is all months in 2003 without displaying the
Quarters.

Thanks

Try:

Select
{ Descendants([Ship Date].[All Ship Date].&[2003] ,<Month Level Name>) }
on Columns,
NON Empty {[Measures].[Load Count], [Measures].[Invoice Amount],
[Measures].[Weight],[Measures].[Miles] } on Rows
FROM
Customer

replacing <Month Level Name> to match your Time Dimension Month Level.

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"SHughes" wrote:

Thank you for the response...

THE MDX worked great...

Ended up looking like this:
Select
{ Descendants([Ship Date].[All Ship Date].&[2003] , [Ship Date].[Month])
}
on Columns,
NON Empty {[Measures].[Load Count], [Measures].[Invoice Amount],
[Measures].[Weight],[Measures].[Miles] } on Rows
FROM
Customer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!