Restricting access in an MDX Subset

[dilip]

I have createdthe Dynamic subsets using MDX query. for every user want only the specific brands for some products..for eg for lux one user should see A,B,C,D brands for TV pana,samsung...etc. this I have achieved but the problem is that when the user is opening the subset(created via MDX query) of brand when he selects 'all' he sees all element in the subset which he doent want.....can you please suggest what can I do.

Regards
Dilip

[Steve Rowe]

The only way to restrict what a user sees when they hit all is to use element based security on the dimension.