Financial Cube notes

Finance Cube, By Accounts aggregation

1. Include Account-key, parent Account-key, account type as attribute while designing account dimention.

2. assign each attribute correct type under accounts or via define Accounts intelligence to the dimension.

3. add unary operator to account dim via adding BI tool or manually

4. Edit databases to do account type mapping.

5. change the AggregateFunction of amount measure to 'ByAccount'.