Typically you would do something slightly different. You would create an
action that went to a URL -- and the MDX would insert various "current
member" values as parameters in the URL. Then within the ASP application,
you can issue whatever you want -- SQL being just one of the options.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Niraj Tenany" <ntenany (AT) hotmail (DOT) com> wrote
Quote:
How can I use an SQL query in an action?
Thanks |