| Info |
|---|
| Info |
Administrators with both the Databases and Sync user permissions can manage dimension groups for a database in the Designer module. This page outlines how to manage groups from within in the Financial Statements , for which youneed module when you have permission to manage custom statements. |
Customize your dimension groups to enhance the analysis capabilities in your financial statements.
Dimensions and dimension groups
A dimension is a subset of data. Dimensions . 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.
Your changes are saved in the underlying database design and, therefore, available to all users who have access to that database. Your dimension groups are included in favorites and dashboards and are also available for use in the Analytics module.
| Expand | ||
|---|---|---|
| ||
Dimensions are subsets of data. They give organization and structure to your data and form the basis of all analysis in Phocas. Each dimension contains multiple entities (also called items or values). For example, a common dimension is Country and its entities can include Australia, the UK, and the USA. In Financial Statements, you see the list of dimensions on the left |
of the grid. You use these dimensions to add levels |
and filter the data to focus on specific |
In a financial database, you always have top-level dimensions for Category and Account, but you typically have other sub-dimensions based on those dimensions, such as Sub Category, Region, and Branch. These sub-dimensions are referred to as dimension groups and they also display in the dimension list.
Dimensionitems. The list contains two classes of dimensions:
See Overview of the link between financial statements and dimensions for more information. |
| Expand | ||
|---|---|---|
| ||
As dimensions are a way of grouping data, additional dimension groups are useful for many reasons, but they’re particularly valuable:
|
What you can do
You can edit an existing dimension group (change its name or define the order of its items), delete a group that is not in use, or add a new group to meet your business needs.
Your changes are saved in the underlying database design and, therefore, available to all users who have access to that database. Your groups are included in favorites and dashboards and also available for use in the Analytics and Budgets and Forecasts modules.
Manage groups in Financial Statements
INTRO
Watch this video to learn how to manage your dimension groups within Financial Statements or read the detailed instructions below.
Get started with groups
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.
In the Groups window, select the Select the top-level dimension for which you want to manage groups, for example, BranchCompany. 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.
Proceed to add new groups or edit or delete the groups as required.
Filter the items
Properties: If there are many properties against a particular dimension, you can see which ones you want to bring in to help you classify your items.
Activity: , so that you have some, you know, branches and stuff with no activity. You can still map them.
Mapped and unmapped: and we'll be looking to move the match and unmet options into this kebab menu as we want them to be column specific. So that's a bit of work we're working on at the moment.
Search for an item:
Sort by a range:
Import export from Excel.
Add a group
With the required dimension selected in the Groups window, click New Grouping… A new 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.
| Tip |
|---|
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. |
Find specific entities (sort and filter)
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.
Add a group
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.
Clone a group
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.
Add a new group from scratch
Edit a groupIn the Groups window with the required top-level dimension selected, click the Add button. A new group column with a default name (Dimension 1) displays in is added to the grid.
Change the group’s default name to something more meaningful, for example, Branch Manager.Select the rows of the items in the grid and type the name of the new entity into the new 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 step to assign the other rows to an entity.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 Build Now to rebuild the database with your changes and view the results.Click Save and closeSave and close to save your changes without triggering a database build. Your changes will take effect on the next database build.
The new groups display in the applicable position in the dimension list next to the statement grid. For example, if you added a group for Branch Manager…
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.
Rename or delete a group
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.
Apply a custom sort order
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 groups
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.
Import groups
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,
Manage groups in Designer
TO DO
See Modify a database > Customize dimensions (hide the code, create groups, and include a group as a property)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.
Create sub-dimensions for accounts
| Info |
|---|
On September 03, 2024, we began the process of migrating the account mapping feature to Groups. The first phase in the migration involves the creation and mapping of account sub-dimensions. 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 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.
| Info |
|---|
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.
| Info |
|---|
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 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.
View the new dimensions in Financial Statements
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.
View the new dimensions in Designer
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.
The following video is useful for administrators or users who look after the design of the financial database.
On this page
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Related pages for administrators
Designer (learn about the Dimension component of a database)