Can we achieve a functionality similar to the LIKE operator in SQL?

I have a cube with data as follows:
Measure1
ABC Corp 10
ABC Limited 20
ABC INC 20

These are basically same companies having different names

I want a result set that would display:
Measure2
ABC 50

That is SUM (all members that start with ABC)

this should be dynamic thru MDX .Is there a way for this?

Appreciate your thoughts on the same.

Regards,
Pras

For filtering, InStr VBA function can be used. For example,

Sum(Filter(Dim.Members, InStr(Dim.CurrentMember.Name, "ABC") > 0), Measure1)

Ohjoo


"pras" <prasannat (AT) gmail (DOT) com> wrote

Thanks for your response
But the issue is it should be dynamic as i have similar set of records
for many other companies
XYZ 1
XYZ 2
XYZ 3
YY 1
YY 2
YY 3

Appreciate your response again.

Regards,
Pras

Ohjoo Kwon wrote:

I don't understand fully what you mean.

Do you mean creating Grouping members by your criteria dynamically?

"pras" <prasannat (AT) gmail (DOT) com> wrote