I have a syntax issue. I can run the last line of this query in the
MDX sample application and get results. I am trying to add the
drilldown function to my URL Action in AS and I receive the error
"Unexpected end of expression" The first two lines run, but when I add

the last line I receive the error.


"http://intranet web address for reporting services" +
[Dimension].Currentmember.Name +


DrilldownLeveltop({[Dimension].member},10,,[Measure])


Thanks for any help.

The DrilldownLeveltop() function will return a set, not a string. It
depends what you want to have concatenated to the url, but at the very
least I imagine that you would need to wrap the function in a call to
SetToStr(). But I don't know how your report will parse this
information.

eg.

"http://intranet web address for reporting services" +
[Dimension].Currentmember.Name +

SetToStr(DrilldownLeveltop({[Dimension].member},10,,[Measure]))


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1131410891.442360.59470 (AT) z14g2000cwz (DOT) googlegroups.com>,
wiltpam (AT) yahoo (DOT) com says...

Darren,

Thank you for the reply. Sorry, my question was a little convoluted.
I understand that the Drilldownleveltop () function returns a set.
That is what I need. I was able to obtain the top 10 results I wanted
in the MDX sample application using this function. I am responsible for
having this result available in reporting services that is why I am
trying to create an action with this query in it. Someone else is
responsible for creating the report. In the Action Wizard, I did read
something about the syntax must return a string. Is it not possible to
use a MDX query in an action that returns a set? When I added SetToStr
to my query I received an error.

"http://intranet web address for reporting services" +
SetToStr(DrilldownLeveltop({[Dimension].Currentmember},10,,[Measure]))

Thank you.

No you can't, the url needs to be a string.

It's hard to say what this would be without more details about the
error.

I have another suggestion. Why don't you just pass
[Dimension].CurrentMember.UniqueName in the action query and get the
person building the report to do the DrilldownLevelTop() query in the
report?

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1132015818.130677.208560 (AT) g49g2000cwa (DOT) googlegroups.com>,
wiltpam (AT) yahoo (DOT) com says...