Is it possible to create a filtered calculated measure? We have 2 large
dimensions that don't filter well (or at all) on our front end application
accessing the cubes.
These dimensions have lots of small values that the client doesn't want to
see when analyzing the individual members of the dimension. However, the
aggregate totals need to be included for all the members of the dimension.
I'm trying to figure out the best way to handle this without affecting
performance.
Asisde from this, performance is pretty good. I would also like to avoid
create a seperate cube or dimension just for this issue.Any suggestions on
the best way to do this in SSAS (SP1)?

Thanks in advance,

-Troy