I have a query which returns some summary values for last Month, the
last 14 days, and a to date summary based on a specified dat, which is
always the previous saturday from when the query was run. This query is
ainfully slow and I realy do not know where to start in speeding it up.
It is hitting a cube which is partitioned at the month level and each
partition points to a seperate fact table.



WITH MEMBER [Time].[YMD].[To Date] AS ''AGGREGATE({[Time].[YMD].[All
Time].[2000].[January].[1]:[Time].[YMD].[All
Time].[2005].[August].[6]})''
SELECT
{[Time].[YMD].[All Time].[2005].[July],[Time].[YMD].[All
Time].[2005].[July].[24]:[Time].[YMD].[All
Time].[2005].[August].[6],[Time].[YMD].[To Date]} ON COLUMNS,
NON EMPTY NEST (
NEST (
[Product.DP].Members,[Product.Title].Members
)
, {
[Measures].[Launches]
,[Measures].[Games Played]
,[Measures].[Players]
,[Measures].[Time Played]
,[Measures].[Avg Time per Player]
}
) ON ROWS
FROM [GameStats Activity]