This answers the question - "How to convert MDX Set to number". There is
nothing that needs to be done to convert MDX Set to expression, since MDX
Set is already valid MDX expression.
--
==============================*=================== =
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebL*og/mosha
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.
==============================*=================== =
"Darren Gosbell" <xxx (AT) xxx (DOT) com> wrote
Quote:
How can i convert a MDX set to an MDX expression
Typically you would apply one of the aggregate functions over the set,
have a look at the AGGREGATE() and SUM() functions in BOL.
--
Regards
Darren Gosbell [MCSD]
dgosbell_at_yahoo_dot_com
Blog: http://www.geekswithblogs.net/darrengosbell |