I have a MDX query giving me data for following states:
MA
NH
CA
NY

Now requirement is one case I want All Locations and second case I want all
except "CA".
How can it possible with one MDX query?

Thanks,
Sam

Will the Except() function work for your case, like:

Non Empty Except(
[Customer].[Customer Geography].[Country].&[United States].Children,
[Customer].[Customer Geography].[State-Province].&[CA]&[US]) on 1
from [Adventure Works]

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Deepak,
The Except function did not work, but let me reephrase my requirement. In
report I am comparing uniqunames.
Ex: Reports location dataset giving me list of location dimension unique
names. The parameter from UI is also location unique name. When this matchs
whith reportlist gives me resultset.
So now question is, can I add a Unique Name in reports dataset MDX query
with exclusion of "CA"

Thanks,
Sam

"Deepak Puri" wrote:

Hi Sam,

Could you possibly translate you requirement to Adventure Works, with an
example or 2 - I'm somewhat stumped by your description?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***