Hi,

Anyone know why function "Contains" would not work for me (error states
that it does not exists) even it is described in Books Online?

Thanks

This is a bug in BOL. There is no MDX function with such a name in AS2005.

--
==============================*=================== =
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.
==============================*=================== =
"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

Thanks for confirming this. So which function should I use to check if
member/touple is in set?
Currently I am using intersect and then result set count is 1, that means
this tuple in the set.
Any better way to do same thing?

Thanks


"Mosha Pasumansky [MS]" <moshap (AT) online (DOT) microsoft.com> wrote

Another way of doing it is to call Rank. Depending on the set, and on the
order in which you put parameters for Intersect - it may be more or less
efficient.

--
==============================*=================== =
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.
==============================*=================== =
"Vimas" <Vimas (AT) NoSpam (DOT) com> wrote