The bit i'm stuck on;
Using SQL 2005, I have a cube with 2 fact tables in it. If I bring in a dimension related to the 1st fact and a measure from the 2nd fact, the measure values are all the same i.e.
Each record in Fact one has multiple records in fact2 so I joined it on fact1's ID. Is there some other relationship I need to add in so the Total Copies gets split up as per the dimensions bought in from Fact1?
(full explanation to follow; just typing it!)