Many to many relationships

[LucasC]

Hello,
I am having some aggregation problems with a cube.
I have a Many-To-Many relationship in my DataWarehouse that I solve it through a Weighting Table.
The problem appears when I tried to use OLAP because if I add this Weighting Table as a dimension it causes bad

aggregations.

Description:
A Units (Dimension) has many Links to another related items (Links Dimension)
Those Links may apply to more than one Unit.

So if I add the Links Dimension and a Unit is associated with more than one Link the Sum is returning SUM(Unit value *

Links Count)

I would like it just to return the sum(Unit Value)

I tried with two cubes (One including this the Links dimension and the other excliding it) and a Virtual cube to solve the

intersections but It doens't work well enough.

Any Idea will be welcome

Thanks

Lucas