Complex MDX Named Set

I have MDX query shown in the code section.
It is giving me The set of tuples (graphic attached)

What I'd like to do is Transform this query into a named set.

Basically i'm trying to find out if there is a way do use the WHERE key word inside of the Named set...
SELECT {} ON 0,
[School Agencies].[DISTRICT NAME].Members ON 1 FROM STUDENT
WHERE ({
[School Agencies].[AGENCY ID].&[28-0001-000],
[School Agencies].[AGENCY ID].&[28-0017-000],
[School Agencies].[AGENCY ID].&[55-0001-000]
})

Open in new window

screenshot.jpg
LVL 7
the_bachelorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Megan BrooksSQL Server ConsultantCommented:
I am just coming up to speed with MDX myself, but it seems like you could in effect move the WHERE restriction into the row axis set, something like the example below. I tried this with a similar query against one of my own cubes and it seemed to work.
The exists relates the row output set to the filtering (School Agencies) set without including the latter in the output.

SELECT {} ON 0,
Exists([School Agencies].[DISTRICT NAME].Members, 
{
[School Agencies].[AGENCY ID].&[28-0001-000],
[School Agencies].[AGENCY ID].&[28-0017-000],
[School Agencies].[AGENCY ID].&[55-0001-000]
}) ON 1 FROM STUDENT

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
the_bachelorAuthor Commented:
'tis what i needed.
short & sweet.
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.