The Time dimension defines the time periods in your model. These can be months, weeks, days, quarters, full years, in fact any kind of periodic division you like.
by default any new model starts with 12 months running January to December, a half year total and a full year total. These can be re-arranged if necessary to reflect a different financial year calendar.
For each time period in your model, you need to enter the following information:
- Name – A reference name for the period. This must be unique and must not contain any spaces or special characters.
- Description – A description for the period
- Type – Either Period, Total, OpenBal or Spread.
Type Used For Period A standard time period running in sequence with other periods Total A time period used for calculations such as quarters and year totals etc. or for additional periods that are outside the standard calendar sequence OpenBal A special type of period used in financial models to bring forward opening balances from the prior year closing. If used, the OpenBal should come immediately prior to the first Period type in the time dimension. A version must be Time Linked in order to bring forward balances. For more information on time linking and opening balances see…….. Spread A particular period type used in conjunction with the in-built forecasting features of Cubix which allows automatic spreading of forecast targets over time periods.
- Cumulative Reset. Specifies which periods represent the start of time based accumulation. The first standard time period would normally be a cumulative reset point as would the first of any quarterly totals.
Post your comment on this topic.