rollup calculations in Account hierarchy (parent-child type)

[Former Member]

Hi,

I want to create a parent-child relationship type Account hierarchy using Universe. The hierarchy has to support different set of calculations for roll ups action for different branches in the same level.

Eg.

Balance Sheet

(+)Assets

(-)Liabilities and Owners Equity

Net Income

(+)Operating Profit

(+)Other Income and Expenses

(-)Taxes

Balance Sheet = Assets -Liabilities and Owners Equity

Net Income = Operating Profit + Other Income and Expenses - Taxes

Regards, Sujeev

[Former Member · Accepted solution]

Measures automatically roll up.

Whether you define your measure with an aggregate or not, if the projection is set to Sum, it will roll up.

Measures that are to be summed should have Sum() wrapped round them at the universe level though.

What you may have is a lot of positive values in your database and no negatives.

If that's the case, you will need to use a case statement to determine the sign of the value.

E.g.

Sum(CASE WHEN Type='Asset' THEN table.value WHEN Type='Liability' THEN -1*table.value ELSE 0 END)

[Former Member · Accepted solution]

Hi,

Thanks for your reply.

I'll do the necessary changes in my table values (sign) according to the nature (Profit/ Loss). I'll check the outcome and let you know.

Regards, Sujeev