Hello all,

I have following the query and the performance is VERY poor.
Can anybody help me optimize this query? Perhaps, the database design
may be revamped...

sum({Descendants([Projects].CurrentMember, [Projects].[Project Id])},
(iif([Time].currentmember.level.name <>
"Month",sum({tail({Filter({Descendants([Time].currentmember,[Time].[Mont
h] )
}, sum({[Project Status].[All Project Status]},[Measures].[Project Count
Help])>0)
})},[Measures].[Project Count Help]),[Measures].[Project Count Help])))

Please help,

Audrey

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

are you using MOLAP?

have you read everything at www.sqlserverperformance.com

good luck


"Audrey Ng" <odd26uk (AT) yahoo (DOT) co.uk> wrote