Hi all ,
I am using a Pivot table to display reports using results
of an MDX query. Now I need to give the user an option to
filter the results between a from date and to date. I am
not able to set the filter as part of the MDX query
because Pivot table(OWC10) doesn't support MDX queries
with named sets like the one below

WITH SET [Date Range] AS '{ [Time].[2002].[May].[19].[6] :
[Time].[2003].[January].[1].[1] }'
MEMBER [Time].[Range] AS 'Aggregate([Date Range])'
Select TopCount({[Employee].Members},3,[Measures].[Hit])
on rows,{[Pages].Members} on columns from HitReport
WHERE [Time].[Range]

Also filtering in Pivot table directly can only be done
for specific values and including a range is not possible.

Can someone help me on this ?


Many thanks
Brigitta