Income Statement Cube

[Trevor]

Has anybody designed a cube for an Income Statement. My
fact table stores items at their lowest levels and I need
to do some rollups:
1. Rebate line items rolled up to a new line item called
Rebate Total
2. Total Income less Total Expense to be calculated as a
new item called Net Income
3. Net Income cost per litre item being the Total Net
Income for a month divided by the sum of all litres for
the year.

Any ideas would be appreciated

Thanks Trevor