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
