Transform Reporting and Unlock Financial Insights with Dimensions

Dimensions is a a powerful capability that helps an organisation to produce complex reports by enriching data when processing journals and documents.

Dimensions are tags that can be applied on master data (customers, vendors etc.) and transactions like journals and documents.

These tags (dimensions) can be anything you want: a department, a region, a customer group, a service type. Their purpose is to facilitate slicing and dicing data, and extract insightful reports needed by the business.

Let’s take the following scenario: a toy manufacturer is producing toys for several age groups, sells the toys in five regions and via three distribution channels.

Naturally, the business wants to know their top seller products, where are their customers, how their products reach the market.

Financially, this translates in knowing revenues and profits for each age group, region, and channel combination.

No stress, that’s the very reason Dimensions exist in Business Central.

Create three Dimensions: Age Group, Region, Channel
For each Dimension add the Dimension Values
Link each Item (toy) to an Age Group dimension value and each Customer to a Region and a Channel dimension values
Operate as per usual – once dimensions are linked to Customers and Items they will be carried over to documents and journals.
Define and Run a Financial Report

Tips
Can be defaulted to master data
Can block or limited specific dimension combinations
Same as Chart of Accounts, dimensions can have totals and subtotals
Use Dimension Priorities to resolve dimension conflicts
You made a mistake? No problem, here how to correct