web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Dimension Set / How to...
Small and medium business | Business Central, N...
Suggested Answer

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

(0) ShareShare
ReportReport
Posted on by chris197 50

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? 

pastedimage1648305736042v1.png

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

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,089 Super User 2025 Season 2 on at

    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

    pastedimage1648424401826v1.png

    3:

    Area 40

    CustomerGroup MEDIUM

    SALESPERSON JO

    pastedimage1648424453474v2.png

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

    Create a new sales line. Set dimensions.

    pastedimage1648424566585v3.png

    Dimension Set ID is 20.

    pastedimage1648424593052v4.png

    The dimension set.

    pastedimage1648424666599v5.png

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

    pastedimage1648424740403v6.png

    Hope this will help.

    Thanks.

    ZHU

  • chris197 Profile Picture
    chris197 50 on at

    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 Profile Picture
    YUN ZHU 97,089 Super User 2025 Season 2 on at

    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

    pastedimage1648427886789v1.png

    pastedimage1648427918757v2.png

  • chris197 Profile Picture
    chris197 50 on at

    Got it! Excellent - thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,167

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,184

#3
YUN ZHU Profile Picture

YUN ZHU 1,161 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans