We are still fairly new at OLAP Cubing and are stuggling with MDX as applied
to an action.

We have a cube that provides details of the number of jobs in our database
by client, state, start date, end date, etc. As an example we may discover
that after drilling into the data that there are 5 jobs for Client A that
were started in Q3.

We need an action that will go to a URL of our web application that will
list these jobs so the user may see the details.

I guess it is possible to create a URL of the format
http://www.ourwebsite.com/search.asp...lientA&Time=Q3 However due to the
number of dimesions we would prefer not to do this since the search.asp page
would require a lot of coding and intelligence. In addition, we are
planning on having lots of cubes and a more generic solution is being
sought.

We would prefer to have the search URL in the format of
http://www.ourwebsite.com/search.asp...0,45,322,47,19

How do we do this in MDX?

We have experimented with code like:
"www.ourwebsite.com/search.asp?JobId=" + SetToStr([Measures].AllMembers)
"www.ourwebsite.com/search.asp?JobId=" +
Generate([Measures].AllMembers,"",",")
but these do not work. We have been reading the help and searching the web
but with little luck.

Any suggestions would be greatly appeciated. Thanks in advance.

Regards
Dave A

Dave, what exactly are those numbers in the URL
http://www.ourwebsite.com/search.asp...0,45,322,47,19 ?
Assuming that each level in each dimension has property called ActionCode
which maps the dimension member to the code, your MDX may look like

"www.ourwebsite.com/search.asp?JobId=" +
Client.CurrentMember.Properties("ActionCode") + "," +
Time.CurrentMember.Properties("ActionCode")

etc

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Dave A" <dave (AT) tcpiqdonotspamme (DOT) com> wrote