Manage dimension groups
Customize your dimension groups to enhance the analysis capabilities in your financial statements.
Last updated
Customize your dimension groups to enhance the analysis capabilities in your financial statements.
Last updated
User permission: Manage Custom Statements
Administrators with the Databases and Sync user permissions can manage dimension groups for a database in the Designer module. This page outlines how to manage groups within the Financial Statements module.
See the Overview of financial statements and dimensions page for more information about the link between dimensions and your financial statements.
You can change the name of a group to something more descriptive, delete a group that is no longer in use, or add a new group to meet your business needs. You can also export the group data for validation with other sources.
As dimensions are a way of grouping data, additional dimension groups are useful for many reasons, but they’re particularly valuable:
If your business has a long list of things, such as lots of departments or cost centers. For example, you could create groups for each type of store (franchise or independent) or each size of store (small, medium, or large).
If your business is project-based. You can have individual groups for each project.
If you want to analyze consolidated results. You might want to group your entities in a certain way to help with your analysis.
If you want to reclassify items, something that might be unavailable in your ERP.
Your changes to the dimension groups are saved in the underlying database design and, therefore, available to all users with access to that database. Your dimension groups are included in favorites and dashboards and are also available for use in the Analytics module.
You start in the same way, whether you are adding groups to create new dimensions, editing existing groups, or simply viewing a group's composition.
Open the Groups window: Click the Settings button > Groups in the top-right corner.
Select the top-level dimension for which you want to manage groups, for example, Company. Each entity in that dimension is displayed as a row in the grid. If any dimension groups exist for that dimension, they are displayed as columns in the grid. In the following image, the Company dimension has seven rows (entities) and two groups: Country and Size. The top-level entities are assigned to an entity in each group.
When managing your groups, use the Undo and Redo buttons in the top-right corner to save time when you need to undo or redo the following actions: enter or import data, and create, clone, rename, or delete columns.
The example above is very basic. It’s likely that your top-level dimensions contain many entities, and therefore, there are many rows in the grid. If there are a lot of entities, to manage the groups more easily you can:
Click a column header to sort the items by that condition in ascending or descending order.
Use the filters to limit the number of items that are displayed in the grid:
Properties: Properties give you information about the dimension, which helps you to assign the entities to the applicable group entities. Select the checkboxes of the properties you want to see in the grid.
All (activity): The dimension might contain entities for which there are no transaction activities. It is still possible to map such entities. Select Activity, No Activity, or All as required.
Keyword: The search box allows you to find a particular entity row quickly. As you type a keyword, the grid contents are filtered to display only the items that match. Often you don’t need to enter a whole keyword, as the search results are so fast.
Mapped and unmapped: As you assign entities to a group, you can filter the grid by a specific group column, so you only see the unmapped entities (the entities you have yet to assign to the group). Click the menu button in the column header and select VISIBLE > Unmapped. Filter by mapped entities in a similar way.
You can add a new dimension group from scratch or clone an existing group to save time and reuse the data for another group. Alternatively, you can import the group and entity data.
Cloning is useful when you want to create a new group that’s very similar to an existing group. For example, if you have a group that updates each year, such as Market Strategy, you can clone that group and append its name with the year, then reassign the entities in the group as required.
In the Groups window with the required top-level dimension selected, click the menu button in the column header of the group you want to clone and select Clone. The new group column (clone) with a default name is added to the grid. Proceed to edit the group.
In the Groups window with the required top-level dimension selected, click the Add button. A new group column with a default name (Dimension 1) is added to the grid.
Change the group’s default name to something more meaningful, for example, Country. Click the menu button in the column header and select Rename. The header becomes editable. Overwrite the default name and click out of the header to apply your changes.
Assign the applicable top-level entities to entities in the group:
Save time by assigning multiple entities to a group entity at the same time. Use the sort and filter tools (see section above) to locate the specific items, then select their rows (click and drag to select all rows in a series).
Type the new entity's name into the yellow box in the group column and press Enter. In this example, you select the three Australian company rows and type Australia (entity) into the Country (group) column.
After you add one or more entities to the group, you can select from that list of entities when assigning the subsequent top-level entities to the group.
Repeat the above steps (1 to 3) to add more groups and assign the applicable entities. In this example, you add another group for the size of the company, which can be small, medium, or large.
Select one of these options:
Click Save and close to save your changes without triggering a database build. Your changes will take effect on the next database build.
Click Build Now to rebuild the database immediately and apply your changes. After a successful build, you’ll receive a message asking you to refresh the page, and then you’ll see the new dimensions.
In the Groups window with the required top-level dimension selected, you can rename or delete the dimension groups as follows:
To rename a group, click the menu button in the column header, select Rename, overwrite the name, and then click out of the header to apply your changes.
To delete a group, click the menu button in the column header, select Delete, and click Delete to confirm.
To determine the position of each item in the dimension (entity list), you can apply a custom sort order. Click the menu button in the column header, select Custom sort order. In the Custom sort order window, drag each item up or down to the new position and click OK.
Export the data in the grid for easy validation with other sources.
In the Groups window, with the required top-level dimension selected, click Export in the bottom-left corner. The file downloads to your computer. Click the file to open it in Microsoft Excel.
You can use the exported file as a template to update the group data for that dimension. Ensure the grid has at least one group column. See Import groups below.
Rather than manually adding or editing your group data, you can import it from a Microsoft Excel file. The best starting point is the group export file (see Export groups above) for a dimension, which acts as a template to work from. You can edit the data in the file as required, such as add new groups and entities or change the group-entity assignment, then import the file to quickly update your group data.
In the Groups window, with the required top-level dimension selected, ensure there’s at least one group column in the grid. If there are no group columns yet, add a blank column and give it a more meaningful name it (or you can rename it later).
Export the group data.
Open the exported file in Microsoft Excel, make your changes, then save and close the file.
In the Groups window, with the required top-level dimension selected, click Import in the bottom-left corner.
Locate and select your file, then click Open.
In the Groups import window, review the imported data and select the applicable dimension from the list above each column header (or select Ignore for any columns you don't want to import), then click Apply.
Rename the new group column headers, if required.
Select one of these options:
Click Save and close to save your changes without triggering a database build. Your changes will take effect on the next database build.
Click Build Now to rebuild the database immediately and apply your changes. After a successful build, you’ll receive a message asking you to refresh the page, and then you’ll see the updated group data.
See the Overview of financial statements and dimensions page for more information about the link between dimensions and your financial statements.
On September 03, 2024, we began the process of migrating the account mapping feature to Groups. As a result, all organizations now create and manage sub-dimensions in the Groups window. Any existing sub-dimensions (previously managed in the statement setup window) can now be found here in the Groups window. You now map all your accounts to these groups in the same grid at the same time, regardless of the financial statement in which they appear.
In addition to customizing the top levels of your financial statements, you can add sub-levels (sub-dimensions) to the statements to get a level of detail that you don't have in your original dataset. When you add the sub-dimension as a level in the statement grid, its entities display as sub-levels underneath the applicable category rows.
When using this method to create a dimension, you cannot differentiate at a level lower than a General Ledger account, such as cost center. However, this can be done via the Designer module.
In the Groups window, select Account from the top-level dimension list. Any sub-dimensions you have for any of your financial statements will display as columns in the grid.
Use the Properties column to bring in additional information, such as the financial statement category mapping.
Add a group for a new sub-dimension, if required.
In the sub-dimension group column, add the entities, then map the accounts to those entities.
Use the other groups functionality to manage your accounts, such as export to and import from Microsoft Excel to help with the mapping process, and clone a group and filter the mapped and unmapped items in each column (group). See the other sections on this page to learn how to do all of this.
Apply a custom sort order to the entities, if required.
Select one of these options:
Click Save and close to save your changes without triggering a database build. Your changes will take effect on the next database build.
Click Build Now to rebuild the database immediately and apply your changes. After a successful build, you’ll receive a message asking you to refresh the page, and then you’ll see the updated group data.
After you add the groups and rebuild the database, you’ll see the new dimensions in the dimension list under the top-level dimension. You can then use these dimensions as you would use any other dimension during your analysis.
If you're an administrator with access to the Designer module, you can also view the new dimensions in the database design. In Financial Statements, click the blue menu button next to the database name and select Design database. In Designer, the dimensions are displayed underneath the corresponding top-level dimension. A lock icon indicates that these dimensions cannot be edited here, as they are managed in Financial Statements.