Does anyone know how I would change the below query to dynamically
select only the data for the current month?

With
MEMBER [Measures].[dayname] AS '[Time].CurrentMember.PROPERTIES
("dayname")'
SELECT
{[Measures].[dayname] ,[Measures].[Net Purchase Amount]}ON COLUMNS,
{[Time].[Day].Members} ON ROWS
FROM [Payments and Purchases]

Thank You in advance,
John C

Hi John,

It depends on how "current month" is determined for your Time dimension
and processing setup. A simple scenario would be where the Time
dimension always ends at the current date, so the current month (whether
complete or not) would be the last month in the dimension hierarchy:

MEMBER [Measures].[dayname] AS
'[Time].PROPERTIES("dayname")'
SELECT
{[Measures].[dayname] ,
[Measures].[Net Purchase Amount]}ON COLUMNS,
Descendants(Tail([Time].[Month].Members),
[Time].[Day]) ON ROWS
FROM [Payments and Purchases]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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