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.
FY21 | Europe | |||
Revenue | Cost of Sales | Margin | Margin % | |
Chocolates | 2,675,773 | 744,867 | 1,930,906 | 72.16% |
Sours | 3,132,459 | 805,269 | 2,327,190 | 74.29% |
Taffy | 3,436,924 | 843,154 | 2,593,771 | 75.47% |
Fudge | 1,957,370 | 520,075 | 1,437,295 | 73.43% |
All Products | 11,202,526 | 2,913,365 | 8,289,161 | 73.99% |
Add dimensions to modules
You can select dimensions when you create a module. Pivot your dimensions between Rows and Columns, or display them as Pages.
You can also nest dimensions on a maximum of three levels on columns or rows.
Time
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 Time
Versions
Versions is a default dimension. For example, use versions to compare different scenarios, such as actual and forecast data.
Manage versions in Versions
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
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
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 Lists
Line items
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 Modules
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 Subsets