Some measures (semi-additive measures) are simply not meant to be aggregated (e.g. SUM function..) across specific dimensions, particularly time. Consider for instance inventory levels, staffing demographics or current account balances.
Which aggregate function are you using?
Which perspective are you using?
Do you have a time dimension?
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!