Hi

It's a modelling query I think, not sure how I should setup the cube and dimensions in a way that can achieve this? My users access these cubes via excel and it is a time consuming task for them to select each product one-by-one from a basic products dimension.

Thanks

Adrian