I am attempting to create a dimension, called Products, that needs a
different drill down path for each product type. For example:

Dimension "Products"

--Product Type 1
-->Brand

--Product Type 2
-->Category Code 1
-->Category Code 2

--Product Type 3
-->Item Number

The problem that I am having is that each product type level needs to
be filtered for a specific type of product. For Product Type 1, the
filter might be [code] = 1, and for Product Type 2, the filter might be
[code] = 2, etc... The users want to the ability to 'drill down' a
different path for each Product Type.

I tried creating a hierarchy of the Product dimension, such as
'Products.ProductType1', 'Products.ProductType2', etc... Each of these
are based on a dB view which filters the appropriate [code] value. When
I include each of these 'hierarchy' dimensions into the same cube, the
cube does not produce any data. This is valid, since the records are
being compared to multiple table joins, with each dimension table join
(or dB view in this case) having it's own data filter.

Is there any way to accomplish this in Analysis services?

Thanks,
Steve