Support flattening of columns selected through bridge-tables(many-to-many relationships)

Data warehousing concepts suggests to use bridge-tables to implement many-to-many relationships between cube & dimension or between two dimensions.

Here are few links explaining the bridge-tables
http://www.pythian.com/blog/implementing-many-to-many-relationships-in-data-warehousing/
http://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/
http://stackoverflow.com/questions/2785158/star-schema-fact-1n-dimension-how
http://www.askjohnobiee.com/2013/08/how-to-bridge-tables-and-many-to-many.html

If we look at the following schema :
User :

User interests :

Sports :

User Interests is the bridge table which is capturing the many-to-many relationship between Users and Sports.

If we have a fact as follows :

If analyst is interested in analyzing with respect to user's interest, then the report would the following :

Though the individual rows are correct and the overall revenue is actually 150, looking at above report makes people assume that overall revenue is 350.

The feature ask here is to optionally flatten the selected fields, if fields involved are coming from bridge tables in join path. If flattening is enabled, the report would be the following :