How about using filter?
For example,
Filter(A.Manger.Members, InStr(A.CurrentMember.Name, "joe") > 0)
Ohjoo
"Eric S" <eric.schleicher (AT) gmail (DOT) com> wrote
Quote:
Is there a way (using MDX) to query member names from a dimension by
providing some criteria?
I Think I've seen (in passing) someone using custom VB functions in
Dlls to accomplish something like this...
Here is a sample Scenario
given a dimension (and level), return a list of member names that meet
some criteria.
something like: give me all members of dimension "A", Level "Manager"
containing "joe" (as a substring)... |