The account dimension can be set in many different ways such as: Sales, Assets, Liabilities, Headcount, and Ratios. It is meant to be organized in a hierarchy. Formulas are used to calculate accounts. Aggregate members are based on the Account Type, you will not have to write formulas in this case. Leverage UDs are used to make sure the account structure is lean.
In this phase, you will provide a Corporate Chart of Accounts and Intercompany Accounts. You will then be able to calculate the CTA, Balance, Current Ratio, Current Year Net Income and Prior Period Retained Earnings.
All business units you have will then budget to a summary account level. This only shows the budget expense detail.
The Account Type property allows positive entry like expense/liability so they can be negated during the consolidation period. Another key account property used is the IC account & plug account. Types of accounts are as follows:
Constraints create valid & invalid intersections which can apply any sorts of time data. This will then attempt to enter the Cube. Constraints are important when writing rules, because it controls the number of data cells in a data unit. If a data value is trying to write a Member not within the set Constraint, an error occurs which will then block the data from entering the Cube. There are different types of account constraints: