I posted this yesterday but I don't see it. I want to limit the data similar to a SQL WHERE statement. I can limit it with a FILTER statement when I show the fields on the row axis, but I don't want to show the field, I just want to use it as criteria. So if I want to limit my results to only certain education levels, but I don't need to see the education levels, I want something similar to the MDX below. I know the where clause is wrong, but can somebody help me translate that to MDX? Thanks

SELECT {[measures].[Unit Sales]} On Columns, {[Customer].[Name].members} on rows FROM SALE
WHER
[Education Level].[Bachelor's Degree] OR [Education Level].[Graduate Degree] OR [Education Level].[High School Degree]

Hi,

you can use a calc member to create a:

with member
[Education Level].[My Levels] as
'sum({[Education Level].[Bachelors Degree] , [Education Level].[Graduate
Degree], [Education Level].[High School Degree]})'

SELECT {[measures].[Unit Sales]} On Columns, {[Customers].[city].members} on
rows FROM SALES
WHERE
([Education Level].[My Levels])


Regards,
Matthias

"Andrea Worley" <k_rage (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:E3EB3C24-CC49-41B9-8CF4-E70DDB43171A (AT) microsoft (DOT) com...
when I show the fields on the row axis, but I don't want to show the field,
I just want to use it as criteria. So if I want to limit my results to only
certain education levels, but I don't need to see the education levels, I
want something similar to the MDX below. I know the where clause is wrong,
but can somebody help me translate that to MDX? Thanks.

Thank you, Matthias. That works perfect. I was trying to do a calculated member with a filter and that didn't work at all


----- Matthias Englert wrote: ----

Hi

you can use a calc member to create a

with membe
[Education Level].[My Levels] a
'sum({[Education Level].[Bachelors Degree] , [Education Level].[Graduat
Degree], [Education Level].[High School Degree]})

SELECT {[measures].[Unit Sales]} On Columns, {[Customers].[city].members} o
rows FROM SALE
WHER
([Education Level].[My Levels]


Regards
Matthia

"Andrea Worley" <k_rage (AT) hotmail (DOT) com> schrieb im Newsbeitra
news:E3EB3C24-CC49-41B9-8CF4-E70DDB43171A (AT) microsoft (DOT) com..
when I show the fields on the row axis, but I don't want to show the field
I just want to use it as criteria. So if I want to limit my results to onl
certain education levels, but I don't need to see the education levels,
want something similar to the MDX below. I know the where clause is wrong
but can somebody help me translate that to MDX? Thanks