How do you group base members without a new hierarchy?

We do that using the UD dimensions.

UD1 = location (e.g., Houston)

UD4 = brand (e.g., brand1)

The following locations are brand1, in the Location Text6 field.

Houston, Phoenix, Tampa

The following locations are brand2, in the Location Text6 field.

Seattle, Portland, Las Vegas

The UD4 dimension looks to the the Location Text6 field to determine brand.

REPORTING

We can report on the UD4 Dimension to group Houston, Phoenix, Tampa without referring to the Location dimension hierarchy.

For example, U4#brand1 : A#Sales 

Thanks.  I'd really not want to create a separate dimension for this.  Any other ways?

populate the text# field of those base members with a common value and use the member expansion where(text_ contains ____). see example below where this will return all base branches that contain the word 'budget' in the text2 field property of each base branch member

u2#branches_all.base.where(text2 contains Budget)

Thanks!  I feel like almost all the way there.  That does what I need in identifying the members that have text2 = XYZ.  However, rather than return several instances (where there is "Budget" as text2) by using the equation you specified (I used QV), I want those members grouped together into one cell.