I display an MDX statement on a web page and I want it to have drillthrough.
I was thinking that I could just insert http text into the MDX and it would
show up as a hyperlink on the page. This works, but I am trying to pass in
the row value as the parameter so I can make the drillthrough page filter on
that value. This also works until I try to do it on a calculated value. So,
I make a calculated "Value 3" equal to Value 1 + Value 2. It won't pass me
the name "Value 3", it passes me the name "Value 1 Value 2". Below is an
example of what I am trying from Food Mart. I want the bottom link to say
"www.test.com?test=PostHSDegree, not "www.test.com?test=Bachelors
Degreewww.test.com?test=Graduate Degreee". Any help, please?

WITH MEMBER [Education Level].[Post HS Degree] As '[Education
Level].[Bachelors Degree] + [Education Level].[Graduate Degree]',
solve_order=1
MEMBER [Measures].[HyperLink] As '"www.test.com?test=" + [Education
Level].currentmember.name'
SELECT {[measures].[Unit Sales],[measures].[HyperLink]} on columns,
{[Education Level].[Bachelors Degree], [Education Level].[Graduate Degree],
[Education Level].[Post HS Degree]}
on rows from Sales

You need to bump up the solve order of your second calculated member to
an equal or greater value than the first one. Like this...

WITH MEMBER [Education Level].[Post HS Degree] As
'
[Education Level].[Bachelors Degree] + [Education Level].[Graduate
Degree]
'
, solve_order=1
MEMBER [Measures].[HyperLink] As
'
"www.test.com?test=" + [Education Level].currentmember.Name
'
, solve_order=1
SELECT
{
[measures].[Unit Sales],[measures].[HyperLink]
} on columns,
{
[Education Level].[Bachelors Degree], [Education Level].[Graduate
Degree], [Education Level].[Post HS Degree]
} on rows
from Sales

Just one of the many mysteries of the nebulous solve order and pass
order.