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

Dimension Set / How to identify where a dimension set is used

(0) Share

Report

Posted on by chris197

Question: We have a dimension that was added inadvertenly -- it should not have been added (on the Transaction Dimension Code 000). In a period of a couple of hours something was associated with the dimension set id.

How do I:

1. Figure out where the dimension set ID was actually used?

2. Delete it that use or DIM CORRECT?

3. Allow me to delete the dimension value that was created

MSFT if you are listening I think this process should be easier!

Chris

All responses (4)

Answers (0)

chris197 50 on at

Like (1)

Report

RE: Dimension Set / How to identify where a dimension set is used

Got it! Excellent - thank you.
Suggested answer

YUN ZHU 81,422 Super User 2025 Season 1 on at

Like (0)

Report

RE: Dimension Set / How to identify where a dimension set is used

Hi, Sorry I didn't explain clearly, this page cannot be opened directly.

But you can force Business Central to run "Dimension Set Entry" table by adding the ?table=480 parameter to the URL, such as in the following example:
businesscentral.dynamics.com/.../Sandbox02?table=480
chris197 50 on at

Like (0)

Report

RE: Dimension Set / How to identify where a dimension set is used

This is exceedingly helpful, Zhu. Thank you.

One follow up question. How do I actually access the dimension set entry? I am not sure how to open it. That may be a dumb question but I can't find it.

Is there a permission setting involved?

Chris
Suggested answer

YUN ZHU 81,422 Super User 2025 Season 1 on at

Like (0)

Report

RE: Dimension Set / How to identify where a dimension set is used

Hi, A dimension set is a unique combination of dimension values.

You can find the records in table 480 "Dimension Set Entry".

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/design-details-dimension-set-entries-overview#:~:text=A%20dimension%20set%20is%20a,belongs%20to%20the%20dimension%20set.

For example:

1:
Area 40

3:

Area 40

CustomerGroup MEDIUM

SALESPERSON JO

For ease of understanding, let's look at a practical example.

Create a new sales line. Set dimensions.

Dimension Set ID is 20.

The dimension set.

As of now, you can only use the Correct Dimension feature on General Ledger Entries.

Hope this will help.

Thanks.

ZHU