For our application, in order to achieve what we need to we can either use
Sets or many-to-many relationships. As we all know the later allows for more
complex analysis where dimensions are not directly related to the fact
table. However, we need to consider this from a practical point of view as
well as from a support point of view. At present our sets are automated from
the same matrix/table that is used in the many-to-many relationship. So from
a user point of view I would like to know what other users thoughts are with
respects to this and their experience. Specifically could users comment from
the point of view of their performance in each scenario, maintenance issues,
usability by experienced and novice users, any any other points that you can
think of.

Thanks in advance