I'm having trouble understanding how the periodstodate() function works in
MSAS2K5

using the example query from:
http://msdn2.microsoft.com/en-us/library/ms144925.aspx

WITH MEMBER [Date].[Calendar].[First9Months2003] AS
'Aggregate(
PeriodsToDate(
[Date].[Calendar].[Month],
[Date].[Calendar].[Month].[September 2003]
)
)'
SELECT
[Date].[Calendar].[First9Months2003] ON COLUMNS,
[Product].[Category].Children ON ROWS
FROM
[Adventure Works]
WHERE
[Measures].[Order Quantity]

I get the following results:
4,771
4,344
5,179
4,365

for a total of 18,659

which appears to be the total for just September 2003

not the first nine months of 2003 which is 82,410

is there an error in the documentation or are my numbers incorrect?

Thanks

There seems to be a typo in the sample query - it should be:

'Aggregate(
PeriodsToDate(
[Date].[Calendar].[Calendar Year],
[Date].[Calendar].[Month].[September 2003]
)
)'
SELECT
[Date].[Calendar].[First9Months2003] ON COLUMNS,
[Product].[Category].Children ON ROWS
FROM
[Adventure Works]
WHERE
[Measures].[Order Quantity]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks, Deepak I thought I was losing my mind.

"Deepak Puri" wrote: