Dimensions Deep Dive
Dimensions are Business Central's secret weapon for reporting and analysis. They tag transactions with categories like Department, Project, or Region — letting you slice and dice data without cluttering your chart of accounts.
What are dimensions?
Dimensions are like tags on your emails.
You don’t create a separate inbox for each project. Instead, you tag emails with “Project X” or “Team Y” and filter later. Dimensions work the same way in Business Central — you tag transactions with categories (Department, Project, Region) and then filter reports to see only what you need.
Without dimensions, Olivia would need a separate GL account for every combination: “Sales Revenue - Auckland”, “Sales Revenue - Wellington”, “Sales Revenue - Christchurch”. With dimensions, she has ONE “Sales Revenue” account and tags each transaction with a Region dimension. Much cleaner.
Setting up dimensions
Creating dimensions and values
- Open Dimensions page (Tell Me > “Dimensions”)
- Create dimensions (e.g., DEPARTMENT, PROJECT, REGION)
- For each dimension, open Dimension Values and add the values
| Dimension | Values | Used For |
|---|---|---|
| DEPARTMENT | Sales, Finance, Operations, IT, HR | Cost centre reporting |
| PROJECT | PROJ-001, PROJ-002, PROJ-003 | Project profitability |
| REGION | North, South, East, West | Geographic analysis |
| CAMPAIGN | Q1-Launch, Summer-Sale, Holiday | Marketing attribution |
Dimension value types
Each dimension value has a type that controls its behaviour:
| Type | Can Post To? | Used For |
|---|---|---|
| Standard | Yes | Regular dimension values for transactions |
| Heading | No | Group headings in reports (bold, non-postable) |
| Total | No | Sum of a range of values (calculated) |
| Begin-Total / End-Total | No | Defines a totalling range |
Global dimensions and shortcut dimensions
Not all dimensions are equal. Business Central gives special status to some:
| Type | How Many | What's Special | Performance |
|---|---|---|---|
| Global Dimensions (1 & 2) | Exactly 2 | Stored directly on ledger entry tables. Can filter any list page. | Fastest — native columns |
| Shortcut Dimensions (3-8) | Up to 6 more | Show as columns on journal lines and document lines | Fast — indexed separately |
| Other Dimensions | Unlimited | Available on entries but not as direct columns | Standard — dimension set lookup |
Choosing your global dimensions
Your two Global Dimensions should be the dimensions you filter on most frequently. Common choices:
| Choice | When It Makes Sense |
|---|---|
| Department + Project | Service companies, consulting firms |
| Department + Region | Geographically distributed businesses |
| Department + Cost Centre | Manufacturing, large operations |
| Business Unit + Product Line | Multi-product companies |
At Coastal Traders, Olivia chooses Department (Global 1) and Region (Global 2) because every financial report needs to be sliced by department and geography.
Exam tip: Changing global dimensions
Changing global dimensions after data has been posted is a major operation. Business Central must update every ledger entry to include the new global dimension columns. This runs as a background job and can take hours for large datasets.
The exam may ask about the implications of changing global dimensions. Key points:
- It requires exclusive access (no other users during the change)
- It’s a background process that can be paused and resumed
- Existing entries get updated — the dimension data isn’t lost, it’s restructured
- Plan this carefully — do it during a maintenance window, not mid-month
Default dimensions
Default dimensions automatically populate when you create a transaction for a specific master record. This saves time and ensures consistency.
Default dimensions for master data
You can set default dimensions on:
- GL Accounts — every posting to this account gets the dimension
- Customers — every sales transaction for this customer
- Vendors — every purchase transaction from this vendor
- Items — every inventory transaction for this item
- Fixed Assets — every FA transaction
- Employees — expense and HR-related postings
Value posting rules
Each default dimension has a Value Posting rule that controls enforcement:
| Value Posting | What It Does |
|---|---|
| Code Mandatory | A dimension value MUST be entered (can be any value) |
| Same Code | The specific default value MUST be used (no changes allowed) |
| No Code | The dimension must be LEFT BLANK (prevents accidental tagging) |
| Blank (empty) | No restriction — the default is suggested but can be changed or removed |
Example: Olivia sets Customer “Big Corp Ltd” with default dimension REGION = NORTH, Value Posting = Same Code. Every sales invoice to Big Corp MUST use REGION = NORTH. No one can accidentally tag it as SOUTH.
Default dimension priorities
When a transaction involves multiple master records (e.g., a sales line has both a customer and an item), each might have a different default dimension value. Priorities resolve conflicts.
How priorities work
- Open Default Dimension Priorities (on setup pages like Sales & Receivables Setup)
- Assign a priority number to each source (lower = higher priority):
- Customer: Priority 1
- Item: Priority 2
- GL Account: Priority 3
When a sales line to Customer “Big Corp” (REGION = NORTH) includes Item “Widget” (REGION = SOUTH), the customer wins because it has priority 1.
Blocking dimension combinations
Sometimes certain combinations of dimension values don’t make sense. Priya can block them to prevent errors.
Types of blocking
| Block Type | What It Does | Example |
|---|---|---|
| Block entire combination | Two dimensions can never be used together | IT Department + Sales Campaign (IT doesn’t run sales campaigns) |
| Block specific values | Specific values of two dimensions can’t combine | Department = HR + Project = CLIENT-WORK (HR doesn’t do client projects) |
| Limit to specific combinations | Only listed combinations are allowed | Only allow valid cost centre + department pairings |
Olivia uses blocking to prevent the finance team from accidentally posting expenses to the “Sales Campaign” project. If someone tries, Business Central shows an error.
The Dimension Correction Tool
Mistakes happen. Someone posts an invoice with the wrong dimension. Before the Dimension Correction Tool, fixing this required reversing and reposting entries.
How correction works
- Open Dimension Corrections (Tell Me > “Dimension Corrections”)
- Create a new correction
- Select the ledger entries to correct
- Specify the dimension changes (add, change, or remove dimension values)
- Validate the correction (checks for blocking rules, mandatory dimensions)
- Run the correction — updates the dimension set on the selected entries
Exam tip: Dimension Correction limitations
The Dimension Correction Tool:
- Updates dimension sets on existing entries (doesn’t create new GL entries)
- Can correct General Ledger entries, Customer/Vendor/Bank/FA/Item ledger entries
- Requires appropriate permissions
- Creates an audit log of all corrections
- Does NOT change the debit/credit amounts — only the dimension tags
Default dimensions for account types
Beyond individual master records, you can set default dimensions for account types (all customers, all vendors, all items, etc.):
- Open the Default Dimensions page from the relevant list (e.g., from the Customers list)
- Set dimensions that apply to ALL records of that type
- Individual record defaults can override the type-level defaults
This is useful when every customer should get a DEPARTMENT = SALES dimension by default, but specific customers override it.
Knowledge check
Olivia wants every sales transaction to be tagged with a Department dimension, and she wants to prevent users from leaving it blank. Which Value Posting rule should she use?
Priya notices that a batch of 50 purchase invoices were posted last month with the wrong Project dimension (PROJ-001 instead of PROJ-002). What's the best way to fix this?
At Nordic Manufacturing, Sam needs to choose two global dimensions. The company analyses costs by Department and by Production Line. Reports are generated monthly by department and quarterly by product line. Which should be Global Dimension 1?
🎬 Video coming soon
Next up: Dimensions tag your data. Now let’s automate decisions with approval workflows — routing documents for review before they’re posted.