Retain the source dimensions
Keep original currency, market and period attached to the record where relevant. Agree the transformation used for management reporting. A useful summary remains traceable rather than rely on invisible spreadsheet assumptions.
