Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The Usage of weighting factors in many to many realtionship Expand / Collapse
Author
Message
Posted Friday, August 22, 2014 3:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 22, 2014 9:00 AM
Points: 1, Visits: 6
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.
Post #1606161
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse