1. Open the Dimension Editor for the Account dimension.
2. Browse the dimension and then notice how all members aggregate.
The problem with the Account dimension exists because all account members sum up to Net Income. In fact, a column exists, account_rollup, that defines how each of the members should aggregate.
3. Browse the dimension table, account, to view the account_rollup values.
4. In the dimension tree, click the Account Id level, click the Advanced tab of the properties pane, click the Unary Operators property, and then click the ellipsis () button.
5. Select Enable Unary Operators, click Use an existing column, and then click account_rollup in the Existing column list.
6. Click OK.
7. Click the Order By property in the properties pane, and then click Key.
8. Click the Account dimension in the dimension tree, click the Advanced tab of the properties pane, click the All Level property, and then click No.
9. Save the Account dimension and close the Dimension Editor.