How to make calculated member for Children names starting with 'Ab'

[ericblair]

Hi,

I'm kinda new to MDX and wondering if i could get some help on writing a query that will give me the names of 'children'
that begin with "ab"

I've got this so far:
with [Customer].[Customers].[A-Z].[AB] as 'IIF({[Customer].[Customers].[A-Z].&[A].children})'

But not sure where to say children that start with 'Ab'

Thanks for any advice.

 

[MDXer]

You are going to Have to utilize the MembertoStr function to then invoke the VBA SubString function.