TM1 Forum

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

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