Hello,

How would you filter data so that you only get back values for a
particular date range, such as the last seven days. This is the query
I'm using:

SELECT { [Measures].[Sampled Value] } ON COLUMNS,
{ FILTER( [Time Sampled].[Minute].members, [Measures].[Sampled Value]
<> 0 ) } ON ROWS
FROM MOM_Performance
WHERE ( [Computer].[Computer Name].[DEV1], [Performance Names].[%
Processor Time] )

which is good because now it only returns cells (or are they tuples?)
that actually have data in them (the process was being sampled every 15
minutes, so I would have a long series of 14 empty rows). But once I
put that filter in, I'm having difficulty in adding another. I tried
using AND and OR, but to no avail. Any suggestions on this, or on the
general idea of restricting the query to a particular date range?

Thanks!

Assuming that the date is included higher up the [Time Sampled]
dimension hierarchy:

FILTER(Descendants(Tail(NonEmptyCrossJoin(
[Time Sampled].[Date].Members), 7),
[Time Sampled].[Minute]),
[Measures].[Sampled Value] <> 0) ON ROWS
FROM MOM_Performance
WHERE ([Computer].[Computer Name].[DEV1],
[Performance Names].[% Processor Time])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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