I believe in the one source of truth, as the ideal. From many sources one place to store. It also keeps enforcement on data standards easy since you are working in only one location. I think you are describing reporting across different grains. Here I take the lowest grain possible since it is safe to assume that future requirements are not fully known. If need be you can have snapshots of the data at particular points in time (usually month ends for a business) that aggregate on the grain that you want. You can segment different snapshots to different business areas through using schemas.