Welcome to the second instalment of Hidden Gems, the Tecvia series covering Business Central features that cost nothing extra to use but rarely get the attention they deserve. This time, we are looking at Dimensions. If your team exports data to Excel because “the system cannot show it,” there is a good chance Dimensions are the reason why.
Before you read further, be honest about these four questions:
- Has your Dimension setup changed at all since go-live?
- Do managers request one-off analysis that takes hours to produce?
- Are you running reports that lump everything together when you need it broken down by team, area, or project?
- Are users applying Dimensions consistently, or is data quality patchy?
If any of those sound familiar, you are leaving reporting value on the table. The fix is already inside your system.
What Are Dimensions in Business Central?
Dimensions are labels you attach to transactions. They let you categorise entries beyond the chart of accounts, so you can analyse financial data by the things that matter most to your business.
Instead of only seeing totals by G/L account or nominal code, you can break data down by:
- Department
- Project
- Region
- Cost Centre
- Campaign
- Branch
- Product Line
Think of Dimensions as extra reporting columns built into every transaction. A travel expense posts to one expense account, but you can also tag it to the Sales department, a specific region, and a project. That single entry becomes far more useful when you run reports later.
What Most Businesses Actually Set Up
Many businesses treat Dimensions as a technical requirement during implementation rather than a reporting tool.
A typical setup includes two Global Dimensions, often Department and Cost Centre, a short list of values, some defaults applied to customers or vendors, and very little review after go-live. That is enough to get the system live and start operating.
But most businesses do not stay the same size or shape for long. You may now trade across more regions, manage more departments, run more projects, or need clearer visibility on profitability. Yet many teams still rely on a reporting structure built for a much smaller, simpler business.
What You Are Missing
When Dimensions are underused, reporting tends to go manual.
Users export data to Excel because the system “cannot do it.” Finance teams rework the same reports each month. Managers request one-off analysis that takes hours rather than minutes.
Usually the problem is not Business Central. The problem is that the right categories were never captured at transaction level.
With well-configured Dimensions, you can quickly answer questions like:
- What did each department spend this month?
- Which region delivered the highest margin?
- How profitable was Project Alpha?
- What was travel spend for Operations last quarter?
- Which campaign generated the strongest return?
- Which cost centre is over budget?
Instead of building spreadsheets after the fact, the information already exists in the system. You just need the right structure to surface it.
Practical Examples of Dimensions in Use
The most useful Dimensions reflect how your management team already talks about the business. If a director asks about regional performance every month, Region is a Dimension worth having. If project profitability comes up regularly, Project belongs in the list.
Department
Useful for analysing costs and budgets across Finance, Sales, HR, Operations, and other teams. Most businesses already have this one. The question is whether the values are current and whether users apply them consistently.
Project
Ideal for customer jobs, implementations, internal initiatives, or temporary workstreams. A Project Dimension lets you see exactly what each piece of work costs across multiple expense types and time periods.
Region
Helpful for multi-site or multi-territory businesses. Rather than running separate company files or complex account structures, a Region Dimension lets you report by area within a single entity.
Cost Centre
Useful for branches, support functions, or shared overheads where you need internal accountability without creating separate account codes.
Campaign
A strong option for marketing spend. You can track what each campaign costs and, if you tag related revenue correctly, what it returns.
Product Line
Helpful where several revenue streams sit under one business. A Product Line Dimension lets you see the performance of each stream without separating them into different account codes.
How to Set Up a New Dimension
Adding a new Dimension does not need to be a major project. Here is a practical approach.
Start with the reporting question. What do leaders keep asking for that is hard to answer today? If the same request appears every month, it probably justifies a Dimension.
Keep names simple. Use labels that people understand without explanation. Avoid abbreviations that only one person knows.
Keep the value list clean. Too many options create confusion at entry point and messy data in reports. Fewer, clearer values tend to produce better quality data.
Use defaults wherever possible. Business Central lets you set default Dimension values on customers, vendors, accounts, and jobs. The less users have to think about Dimensions at point of entry, the more consistently they apply them.
Explain why accuracy matters. Users who understand how Dimensions feed into reporting take more care with them. A short internal note explaining which Dimensions matter and when goes a long way.
Review them regularly. As the business changes, your Dimension structure should change with it. Build in an annual review at minimum, or after any significant restructuring.
Common Mistakes to Avoid
Even well-intentioned setups can create problems if you do not maintain them properly.
Too many choices. If users must select from a long list for every posting, quality drops quickly. Keep the list of values to what you genuinely use for decisions.
Duplicate information. Avoid recreating data that already exists elsewhere in the system unless a clear reporting benefit justifies it.
Inconsistent naming. North, NORTH, N Region, and North Region should not all exist as separate values. Pick one format and enforce it across the system.
No clear owner. Someone needs to manage the list of values, maintain naming conventions, and decide when new entries are added. Without ownership, Dimension data becomes messy and unreliable.
Set and forget. Dimensions designed for a 20-person business rarely suit a 60-person business. Review them whenever the structure of your business changes.
The Copilot Connection
As Microsoft builds Copilot deeper into Business Central, structured data becomes more valuable, not less.
Natural language prompts work far better when Dimensions are clear and consistently applied. For example:
- “Show me sales by region this year”
- “Compare department spend for Q1”
- “Which projects made the lowest margin?”
- “Summarise campaign costs this quarter”
Good Dimensions improve your reporting today. They also make Copilot features more useful as Microsoft releases them. Businesses with clean, consistent Dimension data will get significantly more from AI features than those without.
Why Now Is the Right Time to Review
Many businesses assume that better reporting requires new software, additional licences, or a development project. Often the fastest improvement comes from using what already exists more effectively.
Open your Dimensions page and ask yourself:
- Are we still using the same setup from implementation?
- Do our Dimensions reflect how the business actually operates today?
- Are users applying them consistently?
- Are we exporting to Excel because we never captured the right categories at transaction level?
If any of those raise doubts, there is probably untapped value already sitting in your current system. Dimensions are one of the most overlooked features in Business Central. They are already included in your licence, they cost nothing extra to configure, and they can significantly improve the quality of your financial and operational reporting.
If you have not reviewed your Dimension setup since go-live, now is a good time to start. Tecvia can review your current setup and help you identify where the gaps are. Visit tecvia.co.uk to get in touch.
FAQs
For anything not covered here, get in touch directly. We’re happy to answer questions specific to your business and your ERP requirements.
Dimensions are categories you attach to transactions so you can analyse data beyond the chart of accounts. You can use them to break down financial data by department, region, project, or any other category that matters to your business. They sit inside every standard Business Central licence at no extra cost.
No. Finance teams usually manage them, but operations, sales, and senior management all benefit from better reporting. Dimensions support any team that needs to understand performance at a more detailed level than the chart of accounts provides.
Enough to support decision-making without creating complexity at the point of entry. Most businesses operate well with two to four active Dimensions. The right number depends on the questions your management team asks most often.
Global Dimensions are the two primary Dimensions that appear throughout Business Central in filters, reports, and account schedules. They are the most visible Dimensions in the system and typically cover the most common reporting categories, such as Department and Cost Centre.
Yes. Many businesses improve and expand their Dimension setup years after implementation. New Dimensions apply to future transactions. Applying them to historical data requires additional configuration, but it is possible.
Adding a new Dimension does not change how existing data is stored. It adds new fields for future transactions. Your current reports and processes continue to work as before.
No. They complement it. The chart of accounts tells you what happened. Dimensions tell you where, who, or why. Both work together to give you a complete picture.
Very often, yes. When transactions carry the right tags, Business Central can produce detailed reports directly inside the system. Many businesses find that Excel exports become less necessary once their Dimension structure reflects how they actually want to analyse data.
No. Business Central’s built-in reporting, account schedules, and filtering all become more useful with good Dimensions. Power BI extends that further, but it is not a prerequisite for better reporting.
Setting them up during implementation and never reviewing them again. A Dimension structure designed for a business at go-live often does not reflect how that business operates two or three years later.
At least once a year, or after any significant change such as an acquisition, a restructure, or expansion into new markets.
Start with Department, Region, or Project. Whichever one reflects the question your management team asks most regularly is the right place to begin.
