By default, all models include the Time and Versions dimensions, and the Organization and Users lists. Other dimensions include Lists, which typically include products, regions, departments, or employees.
Dimensions give context to cell values. The table below shows data from the Country Margin Report module, which has Products on rows, line items on columns, and Years and Regions on pages. Products and Regions are lists, and Years is Time.
Each dimension contextualises the data in the module. For example, the total revenue from Chocolates sold in Europe in FY21 is 2,675,773.
|Revenue||Cost of Sales||Margin||Margin %|
Add dimensions to modules
You can also nest dimensions on a maximum of three levels on columns or rows.
Time is a default dimension. For example, use the Time dimension to anaylze data from the previous year, and to plan for what might happen in the future.
Manage your model's calendar in Timein the model settings bar.
Versions is a default dimension. For example, use versions to compare different scenarios, such as actual and forecast data.
Manage versions in Versionsin the model settings bar.
Organization and Users lists
The Organization and Users lists, default lists, are also default dimensions. For example, use the Organization list to hold your organization details, such as regions and departments.
Lists are a dimension, like Time and Versions. For example, use lists to group similar products, employees in a department, or geographic regions.
List subsets contain list items from larger lists. For example, use list subsets as a dimension if you want to analyse commissions for specific employees in a team.
Manage all lists and list subsets in General Listsin the model settings bar.
Line items are a type of dimension, and represent how data in a module is measured. For example, the Employee Expenses module includes the Start date, Leave date, Salary, and Bonus line items.
Manage line items in Modulesin the model settings bar.
Line item subsets
Line item subsets are another type of dimension, and include collections of line items from the same or different modules in a model. For example, use line item subsets to group calculations together from different modules.
Manage line item subsets in Line Item Subsetsin the model settings bar.