I have to show the top 10 dimension member based on a measure.For example top customer by revenue.In that case I have another dimension value, say the purchase location, which I should bring in the query with comma separated value.

example:

customer revenue purchase-locationcust1 10000$ city1,city2How this should be handled in mdx query.

Thanks Visakh.I tried this already but the issue is, I'm also using a topcount on rows to bring the top revenue records. but this generate part is bringing all the purchase-location irrespective of the customer.