Nick,

What sort of data is in these two tables? I would suspect that the issue that you are seeing with the data not aggregating up as you are expecting it to is due to a dimension in the cube that acts as a switch between the measure groups. Is this a cube that is in a production environment or is this something that someone else starting working on and never finished.

Thanks,

Frank