T
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
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