Hi I am currrently looking for a way to model ssas project with a many to many relationship with a weight in it.
I have file summary fact that has file details - names , spaceGB , share details , cost per GB, Total cost of file ( SpaceGB * Cost per GB)
Share dim that has regular relationship.
We have another mapping table (fact) that gives many to many relationship between Shares and Cost Center and there is a allocation percentage associates with a share across different costcenters
Share Costcenter Allocation%
Share 1 CostCeneter1 50%
Share 1 CostCeneter2 50%
everything works fine as long as i dont show allocation % how do i handle allocation % to get cost center cost.