Dimensions are the lists that workspace administrators select to be a module's rows, columns, and pages. They provide the structure of a module and define the context for data in cells.
Dimensions can be:
- Lists that workspace administrators create in the General lists pane.
You can use list subsets as dimensions if only some items in a list apply to a module's data. - Time, Versions, Users, and Organization, which are default lists that exist in every model.
- The line items of the module, or a line item subset.
The data in a cell has meaning due to the context given by the dimensions that apply to the cell.
You select the lists to use as the dimensions of a module when you create the module. You can change the dimensions that apply to a module's data in the Applies To field of the Modules pane, or in Blueprint view for a module.
Once selected, you can pivot your dimensions to move them between rows, columns, or pages.
Default lists
Default lists exist in all models. They cannot be deleted and are always available to use as dimensions.
Organization
Organization is a default list that can be configured in General lists. It's automatically populated with the list item Total Company. To summarize your data, you Total Company is automatically set as the Top Level item that all other list items roll up to.
Time, Versions, and Users
Time, Versions, and Users are more complex than the lists workspace administrators create in General lists. Each has its own pane where you can configure the specific settings for that dimension and import data.
You can select Time , Versions , and Users from Model settings to open a configuration pane.
Dimensions example
This Country Margin Report module has a Products list on rows, line items on columns, and Time and Countries on pages.
| FY22 | Germany |
| 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% |
The values you select for the dimensions on pages define the context for the module grid: FY22 is selected as the time and Germany is selected as the country. So, the grid displays data for Germany in financial year 22.
The context for each cell is further refined by the values in the rows and columns that apply to the cell. So the cell in the top left, with a value of 2,675,773, is the Revenue from Chocolates sold in Germany, in FY22.
