I am trying to run an MDX query in the MDX Sample Application and I can't
figure out the syntax to properly. Problem:

I have a cube built with 3 dimensions: Time, Question and State.
My cube has 1 measure, "score"

I need to build an mdx query that gives me the "score" values for each
question for the following levels:

All States
Only Illinois and Iowa
All States excluding Illinois and Iowa


I have the syntax for the first 2 items, but I don't know how to create the
last item. I tried using the EXCEPT function, but I keep getting all of the
states, I need to have the "all states excluding Illinois and Iowa" as a
whole. Any help would be appreciated.

I figured this out. You create a "WITH MEMBER " entry similar to :

WITH
MEMBER [State].[All State Except] as 'Aggregate (EXCEPT({[State].[All
State].Children},{[State].[All State].[IL], [State].[All State].[IA],}))'
select
NON EMPTY { [Time].[All Time].[2003].[Q1].[Nov], [Time].[All
Time].[2003].[Q1].[Dec], [Time].[All Time].[2003].[Q1].[Jan] } on columns,
NON EMPTY {[Questions].Children} on rows
from MyCube
WHERE (Measures.[Score], [State].[All State Except])


"Scott Jucovics" <sjucovics (AT) yahoo (DOT) com> wrote

Hi Scott,

EXCEPT is just removing the members you define from a certain set. You need
to do some calculation operations to get the total value eacept Illinois and
Iowa:

with

member [State].[MyState] as
' [AllStates] - [Illinois] - [Iowa] '

select
....

Cheers,
Matthias