Filtering by attributes pax

[samiamsz]

So I created an entry template
In the rows I have the entire item hierarchy.
I need to add a filter at the top which allows the user to filter by 2 different attributes (program, selling type)
I know I can use an max so that is creates a dynamic subset based on the attribute filtered...but in the filter itself, how can I get it to be a drop down of whatever data is in the attributes.
For example the user is provided an interface where for each item they can populate both those text attributes (program, selling type)
Now how can I create a drop down so that whatever text is inputted into the attribute, it will display in the drop down? And then I guess I can use an mDx to filter it

[gtonkin]

An age old problem with very few solutions.

I am guessing many of us use shadow dimensions to build the list of distinct values when processing master data then link that to a SUBNM etc.

I also create Rollups in the dimension based on the attributes a I can then use MDX to get the list of those members back with the added bonus of having Rollups to read aggregate values from if needed.

HTH.

p.s. beware of creating multiple rollups where you have the same C level within multiple rollups, will obviously create duplication issues if they mean different things in each rollup.