Hi,

I have a cube containing several measures.  Some of these measures 
represent financial reserves (provisions) that are additive across any 
dimension except time.  For example, the reserve for a business unit at 
the end of the 1st quarter is the reserve at the end of March, not the sum 
of the reserves at the end of January, February and March.  However, the 
reserve for the organisation at the end of any month would be the sum of 
the reserves of all the business units at the end of that month.

Is there a way to sum these reserves correctly within a cube?  How can I 
direct the process to ensure that only the reserves that fall into the 
last month of an aggregation (whatever month and aggregation that may be) 
are included in the sum?

Any assistance will be greatly appreciated.

Anwar Peck, South Africa