Hello,
How do I support SQL "LIKE" operator in MDX.
eg. select unit_sales, Customer.Name from SomeTable where CustomerName like
"Ni*";
How DO I construct corrosponding MDX statement.

Thanks
Santosh

Hi
Thanks for the information.
Left would solve only the wild card character usage appearing towards the
end of the string.
Again I need to use Right function for certein functions.

what I am looking for , is a capabilities simillar to the regular
expressions.
I do not know much about VBA.
Is there any function in VBA that can take a regular expression string and
return indication that wheather a given string matches the regular
expression or not.

Thanking Again

Santosh
"Jörg" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hello Santosh,
SQL "LIKE" is not able in MDX. But you can
use VBA Functions:

Select
FILTER(
[customers].[name].members,
VBA!LEFT(Customers.currentmember.name,2) = "Ni"
)
on 0 from sales

HTH
Jörg

VBA's InStr function supports wildcards - while not true regular
expression - this is close enough.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
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.
==================================================