The Usage of weighting factors in many to many realtionship

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply