I have seperate product dimension for different region. In the calculated measure there is a case statement as below

case

when [Product-AA Region].[Hierarchy].currentmember.level.name='Brand' then [Measure].[Product Brand]

when [Product-BB Region].[Hierarchy].currentmember.level.name='Brand' then [Measure].[Product Brand]

Issue here is I need to repeat the case statement for all the product dimension. Is there anyway to combine the logic into one case statement?

when *.[Hierarchy].currentmember.level.name='Brand' then [Measure].[Product Brand] ??

Hi GreenHorn123,

According to your description, you want to apply condition with only one case statement which can affect any product region dimension. Right?

In Analysis Services, it's not supported to use one reference pointing to all available dimensions which the lower level hierarchy has same name. In this scenario, it's better to create one dimension which combines all the products region. You can have a higher level for [Product-XX Region].

If you have any question, please feel free to ask.

Regards,