Analysis Services 2000 sp 4. Trying to use Except in MDX Sample Application.
AS 2005 is not an option.

I'm trying to exclude numbers for one client, but my queries will either
run, and return numbers for this client, or it just hangs. I need to figure
out how to do this, and still return my report in a less than 60 seconds.

This query takes forever to finish, and frankly I haven't seen the result:

with
member [Client].[NotSpecialClient] as
'Aggregate(Except(descendants([Client].defaultmember, 0, self),
{[Client].&[101]}))'
select {[Measures].[Invoiced hours],[Measures].[Invoiced
amount],[Measures].[Invoiced hours Cumulative],[Measures].[Invoiced amount
Cumulative]} on 0,
non empty order({[Client Project].children}, [Client
Project].currentmember.properties("Key")) on 1 from
[myCube] where ([Date].[200402],[Transaction type].[Hours],[Budget
Model].[(na)],[Client].[NotSpecialClient])

This query will return a result after some seconds, but
[Client].[Custaccount].&[101] is still being displayed in the list of
clients.

What do I have to do to make Client 101 be excluded from my result? All help
appreciated!!!

Kaisa M. Lindahl Lervik