MS SQL Server OLAP - OLAP URL Action

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

OLAP URL Action

Tim

2005-09-29, 1:23 pm

I've built a URL Action in my OLAP cube and I want the URL to be dynamic
based on the server name. Is there any way through the MDX expression to
retreive the server name and then I can build URL based off an IIF statement?
Is there another way to accomplish this?

Darren Gosbell

2005-09-29, 8:24 pm

I can't think of a way to get this in MDX, but then I have never used
URL actions so someone else my have more ideas.

Another approach could be to have all the URL's point to localhost and
then write a small ASP/ASP.NET app that does the server specific
processing before forwarding the request to the appropriate address.

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

Sponsored Links