Variables are the accounts or data items that you want to have in your model. They can include financial and non financial items, calculated items, KPIs, ratios, statistics or any other type of numeric data that you may want.
For each variable you want in your model, you need to enter the following information:
- Name – A reference name for the variable. This must be unique and must not contain any spaces or special characters.
- Description – A description for the variable
- Type – Either Heading, Transaction or Balanced
- A Heading type variable does not hold data, it just acts as a spacer in the list of variables.
- A Transaction type variable is for data that cumulates over time. For example a cost account where the costs from period 1 are added to the costs from period 2 in order to determine the cumulative total as at period 2.
- A Balanced type variable is for data where cumulation does not take place. For example a cash balance account which is used to report the closing balance as at the end of each period.
- Has Product (optional) – Tick this box if the variable is to be further split for analysis according to the Product dimension
- Product Set (optional) – The set of Products to be used for analysis for this variable. For more information on Products and Product Sets see……………
- Precision – The number of decimal places for this variable
Post your comment on this topic.