Work with dimensions

Dimensions are values that categorize entries so you can track and analyze them on documents, such as sales orders. Dimensions can, for example, indicate the project or department an entry came from.

So, instead of setting up separate general ledger accounts for each department and project, you can use dimensions as a basis for analysis and avoid having to create a complicated chart of accounts. Learn more at Business Intelligence.

Another example is to set up a dimension called Department, then use that dimension when you post sales documents. This way, you can use business intelligence tools to see which department sold which items. The more dimensions you use, the more detailed are the reports you base your business decisions on. In fact, a single sales entry can include information from multiple dimensions, such as:

• The account the item sale was posted to.
• Where the item was sold.
• Who sold it.
• Which customer bought it.

Analyzing by dimensions

Dimensions play an important role in business intelligence, such as when defining analysis views. Learn more at Analyze Data by Dimensions.

Dimension sets

A dimension set is a unique combination of dimension values. They are stored as dimension set entries in the database. Each dimension set entry represents a single dimension value. In addition, each dimension set, and dimension set entry within it, is identified by a common dimension set ID.

When you create a journal line, document header, or document line, you can specify a combination of dimension values. Instead of explicitly storing each dimension value in the database, a dimension set ID is assigned to the journal line, document header, or document line to specify the dimension set.

Setting up dimensions

You can define dimensions and dimension values to categorize journals and documents, such as sales orders and purchase orders. You set up dimensions on the Dimensions page, where you create one line for each dimension, such as Project, Department, Area, and Salesperson.

You also set up values for dimensions. Let's say values represent your company's departments. Dimension values can be set up in a hierarchical structure similar to the chart of accounts. That means data can be broken down into various levels of granularity, and subsets of dimension values can be totaled. You can define as many dimensions and dimension values as you need, and everyone in your company can use them.

When dimensions and values are set up, you can define global and shortcut dimensions on the General Ledger Setup page. These dimensions are then always available for you to select as fields on journal and document lines, and ledger entries, without opening the Dimensions page first. Learn more in the To set up global and shortcut dimensions section.

• Global Dimensions are used as filters, for example, on reports, batch jobs, and XMLports. You can use only two global dimensions, so choose dimensions you will use often.
• Shortcut Dimensions are available as fields on journals, document lines, and ledger entries. You can create up to eight of these.

To set up default dimensions for customers, vendors, and other accounts

You can assign a default dimension for a specific account. The dimension is copied to the journal or document when you enter the account number on a line, but you can delete or change the code on the line if appropriate. You can also require a dimension for posting an entry in a specific type of account. >

1. Choose the icon, enter Dimensions, then choose the related link.
2. On the Dimensions page, select the relevant dimension, then choose the Account Type Default Dim action.
3. Fill a line in for each new default dimension you want to set up. Hover over a field to read a short description.

To set up default dimension priorities

Different account types, such as a customer account and an item account, can have different default dimensions. As a result, an entry might have more than one proposed default dimension. To avoid such conflicts, you can apply priority rules to the different sources.

1. Choose the icon, enter Default Dimension Priorities, then choose the related link.
2. On the Default Dimension Priorities page, in the Source Code field, enter the source code for the entry table to which the default dimension priorities will apply.
3. Fill in a line for each default dimension priority you want for the selected source code.
4. Repeat the procedure for each source code you want to set up default dimension priorities for.

To set up dimension combinations

To avoid posting entries with contradictory or irrelevant dimensions, you can block or limit specific combinations of two dimensions. A blocked dimension combination means you cannot post both dimensions on the same entry regardless of what the dimension values are. In contrast, a limited dimension combination means you can post both dimensions to the same entry, but only for certain combinations of dimension values.

1. Choose the icon, enter Dimension Combinations, and then choose the related link.

2. On the Dimension Combinations page, choose the dimension combination field you want from the following options.

   Field	Description
   No limitation	This dimension combination has no restrictions. All dimensions values are allowed.
   Limited	This dimension combination has restrictions depending on which dimension values that you enter. You must define the limitations on the Dimension Value Combination page.
   Blocked	This dimension combination is not allowed.

3. If you selected the Limited option, you must define which combinations of dimension values are blocked. To do this, choose the field to define the dimension value combination.

4. Now select a dimension value combination that is blocked and enter Blocked in the field. A blank field means the dimension value combination is allowed. Repeat if multiple combinations are blocked.

To set up global and shortcut dimensions

Global and shortcut dimensions can be used as filters in Business Central, including on reports, batch jobs, ledger entry pages, and analysis views. Global and shortcut dimensions can be inserted directly without first opening the Dimensions page. On journal and document lines, you can select global and shortcut dimensions in a field on the line. You can set up two global dimensions and eight shortcut dimensions. Choose the dimensions that you use most frequently.

1. Choose the icon, enter General Ledger Setup, then choose the related link.
2. On the Dimensions FastTab, fill in the fields. Hover over a field to read a short description.

To change global dimensions

When you change a global or shortcut dimension, all entries posted with that dimension are updated. Because this process may be time-consuming and can affect performance, two different modes are provided to adapt the process to the size of the database.

1. Choose the icon, enter General Ledger Setup, and then choose the related link.

2. Choose the Change Global Dimensions action.

3. At the top of the page, select one of the following two modes for running the batch job.

   Option	Description
   Sequential	(Default) The change is done in one transaction that reverts all entries to the dimensions they had before the change. This option is recommended if the company has relatively few posted entries, in which case the batch job takes the shortest time to complete. The process locks multiple tables and blocks other users until it is done. Be aware that with large databases, the process might not complete in this mode. In that case, use the Parallel option.
   Parallel	The dimension change happens in multiple background sessions and the operation is split into multiple transactions. To use this option, turn on the Parallel Processing toggle. We recommended this option for large databases or companies with a lot of posted entries because it will complete in the shortest time. Note that in this mode, the update process won't start if there is more than one active database session.

4. In the Global Dimension 1 Code and/or Global Dimension 2 Code fields, enter the new dimension(s). The current dimensions are displayed in gray behind the fields.

5. Depending on the mode, do one of the following:

   • In Sequential mode, choose the Start action.
   • In Parallel mode, choose the Prepare action.

   The Log Entries tab is filled with information about the dimensions to be changed.

6. Sign out of Business Central, then sign in again.

7. Choose the Start action to begin the parallel processing of the dimension changes.

Example of dimension setup

Let's say your company wants to track transactions based on organizational structure and geographic locations. To do that, you set up two dimensions on the Dimensions page:

• AREA
• DEPARTMENT

For AREA, add the following dimension values:

For the two main geographic areas, Americas and Europe, you add subcategories for regions by indenting the dimension values. This lets you report on sales or expenses in regions, and get totals for the larger geographic areas. You could also choose to use countries, regions, counties, or cities as your dimension values, depending on your business.

For DEPARTMENT, add the following dimension values:

With this setup, you can add your two dimensions as the two global dimensions on the General Ledger Setup page. This means you can use AREA and DEPARTMENT as filters for general ledger entries, as well as on all reports. Both global dimensions are also automatically available for use on entry lines and document headers as shortcut dimensions.

Getting an overview of dimensions used multiple times

The Default Dimensions-Multiple page specifies how a group of accounts uses dimensions and dimension values. You can set this up by highlighting multiple accounts, then specifying default dimensions and dimension values for them. After that, the application suggests these dimensions and dimension values whenever one of these accounts is used, such as on a journal line. This makes entry posting easier for the user, as the dimension fields are filled in automatically. Also note, however, that the dimension values suggested can be changed on, for example, a journal line.

The Default Dimensions-Multiple page contains the following fields:

Use dimensions

In a document such as a sales order, you can add dimension information for both an individual document line and the document itself. So on the Sales Order page, you could enter dimension values for the first two shortcut dimensions on the individual sales lines, then add more dimension information if you choose the Dimensions button.

If you work in a journal instead, you can add dimension information to an entry in the same way, if you have set up shortcut dimensions as fields directly on journal lines.

You can also set up default dimensions for accounts or account types, so dimensions and dimension values are filled in automatically.

To view global dimensions in ledger entry pages

Global dimensions are always company-defined and company-named. To see the global dimensions for your company, open the General Ledger Setup page.

In a ledger entry page, you can see whether there are global dimensions for the entries. The two global dimensions differ from your other dimensions because you can use them as filters anywhere in Business Central.

1. Choose the icon, enter Chart of Accounts, then choose the related link.
2. On the Chart of Accounts page, choose the Ledger Entries action.
3. To see only entries that are relevant, set one or more filters on the page.
4. To see all the dimensions for an entry, select the entry, then choose the Dimensions action.

See also

Business Intelligence
Finance
Analyze Data by Dimensions
Work with Business Central

Find free e-learning modules for Business Central here