Small and medium business | Business Central, N...

Large volume of Dimension Values - Performance

(6) Share

Report

Posted on by SL_GP_BC_123

1,106

We are working with a customer that is looking at implementing a dimension code were where could be adding 1000 or more dimension values during the course of any given year. Given that scenario are there any potential performance issues down the road? The dimensions will be used for P&L's generated from either within BC or within an external reporting tool such as Cosmos.

Look forward to a response.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Aman Kakkar 2,977 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Hi,

So, this is a mix of AI Generated answer, and my personal opinions.

Business Central can handle 1,000+ dimension values in a single dimension very easily. But there are some important performance considerations depending on how the dimension is used.

The real performance load happens when:

1. Posting thousands of G/L entries with complex dimension combinations

Each entry inserts a record into Dimension Set Entry, and dimension set IDs need to be generated.

Having 1000+ values is fine — but having millions of dimension combinations can slow down dimension set creation.

2. Reporting that filters heavily on dimensions

When queries apply:

Dimension filters

Grouping on dimensions

…it means extra joins on G/L Entry → Dimension Set Entry.

This is still OK, but performance depends more on:

Number of G/L Entries

Number of Dimension Set Entries

Number of unique combinations (Dimension Set IDs)

If you expect heavy posting volume and large number of dimension combinations, follow these best practices:

If you add 1000 values every year, consider archiving older ones or marking them blocked.

For complex reporting → use COSMOS/Power BI - much faster for dimension-heavy entries.

Do mark it as verified if this helps,

Aman K

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,808 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Using 1,000+ dimension values is totally fine in Business Central.

BC supports unlimited dimension values, and performance issues only appear if you misuse global/shortcut dimensions or create huge analysis views — not because of the number of values itself.

So yes: large dimension value lists are safe, both inside BC and in external tools like Cosmos.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I think there's no problem with this scale of data.
If you're concerned about performance, I suggest setting this dimension to Global or Shortcut, which will make it easier to retrieve the data during customization.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Adding 1,000+ dimension values in Business Central is supported, but it can lead to performance challenges over time because each transaction creates entries in the Dimension Set Entry table, which grows rapidly and affects posting speed and reporting. Internal reports like Account Schedules and Analysis Views may slow down, while external tools like Cosmos handle large datasets better but still depend on BC’s data extraction performance.

Best practices include limiting dimensions to essential ones, using grouping or hierarchies, scheduling heavy reports off-peak, and monitoring SQL performance with indexing.

For very high volumes, consider a data warehouse or BI strategy for reporting.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,219 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Yes, adding 1,000+ dimension values is supported, but large volumes can slow posting and reporting because of many ledger entry combinations.
Best approach:

> Use shortcut dimensions only for critical ones.
> Keep high-volume dimensions as global only if needed for reporting.
> Archive unused values and optimize reports.

External tools like Cosmos handle large sets better.

Thanks

Rishabh

Was this reply helpful? Yes No