dbTalk Databases Forums  

Convert MDX Set to expression

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Convert MDX Set to expression in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vRam
 
Posts: n/a

Default Convert MDX Set to expression - 11-01-2005 , 03:41 PM






How can i convert a MDX set to an MDX expression


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Convert MDX Set to expression - 11-01-2005 , 03:49 PM






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


Reply With Quote
  #3  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: Convert MDX Set to expression - 11-01-2005 , 04:16 PM



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



Reply With Quote
  #4  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Convert MDX Set to expression - 11-01-2005 , 05:06 PM



Quote:
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.

Very true. I should have pointed out that I assumed you were trying to
create a calculated member. If this is not the case there may be another
syntax error in your MDX and it will be hard to diagnose without seeing
the actual MDX.

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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.