I created calculated members in the cude calculating the different percentiles
I need a report with the different percentiles for each grade EXCLUDING the client doing the query

something like this
SELECT
{[25th Percentile],[75th Percentile]} on 0
{[Grade].[A1],[Grade].[A2],[Grade].[A3]} on
FROM myCUB
WHERE not ([Client].[WhatEver]
o
WHERE ([Client].[1st],[Client].[2nd],[Client].[3rd]

According to the MDX spesifications we should be able to specify multiple tuples from the same dimension; but Microsoft's implementation does not support it

Any workarouds/suggestions

This recent post on the newsgroup addreses it:

http://groups.google.com/groups?q=md...l=en&lr=&ie=UT
F-8&oe=UTF-8&selm=nasfb.157%24Il3.59972%40news.uswest.net&rnu m=2
Subject: Re: supporting not operator in the slicer for mdx
View: Complete Thread (3 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.olap
Date: 2003-10-03 21:40:09 PST

An MDX WHERE clause is a tuple. Since only one member per dimension can
go
in a tuple, the only way to do this is by creating a calc member that is
an
aggregation of the set, like so:

WITH
MEMBER Store.AggStores AS
' Aggregate ({ [Store Name].Members - {[Store 1]} }) '

SELECT
etc...
WHERE (Store.AggStores)

- Deepak

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