Are there any wild card characters in MDX like there are in SQL?

For example I can do this in SQL:

Select * from Employees
where name like 'abc%'

Can you do that with MDX?

Thanks,

Shab

** The contents in this message are provided as is and is not guaranteed
to be correct **

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can use the MDX Filter() function and the VBA text functions to have
plenty of search functionalities...

Contains Search : filter ( <<set>>, instr(<<dim>>.currentmember.name,
<<searchstr>>)>0)
Exact Match: filter ( <<set>>, <<dim>>.currentmember.name= <<searchstr>>)
Starts with: filter ( <<set>>, left(<<dim>>.currentmember.name,
len(<<searchstr>>))="<<searchstr>>")

Cheers,
Sanka



"shab nash" wrote:

OK. I had found out how to use filter with = and left and right but I
didn't know I could use Instr in there. Well,thanks. This makes it much
easier.
So what if I want to find out if a string has *a*b* in it? I have to
parse it and break it into : instr(mystring,1)*instr(mystring,b)>0 ? Is
there a single function in VB that does that?

Thanks,

Shab


** The contents in this message are provided as is and is not guaranteed
to be correct **

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi,

MDX Functions in Analysis Services

http://msdn.microsoft.com/library/de...intro_65iw.asp

Kindly look at the "Registered Function Libraries" section which explains
about the list of available VBA and Excel functions which can be used with
Analysis Services 2000.

Cheers,
Sanka


"shab nash" wrote:

Thanks for the list. I am implementing the wildcards with Instr.

Shab

** The contents in this message are provided as is and is not guaranteed
to be correct **

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!