I have a dimension named Products with the following hierarchy:

Type
Sub Type
Product

Due to requirements I want that a particular product, whose name is, say, "XYZ" should not be displayed when the user drills down to the lowest level i.e. the Product level.

I tried playing with the Advanced Properties tab but could not make any progress and thus will be grateful for help.

Thanks.