Skip to main content

Notifications

Announcements

No record found.

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

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

Posted on by 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

  • chris197 Profile Picture
    chris197 50 on at
    RE: Dimension Set / How to identify where a dimension set is used

    Got it! Excellent - thank you.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    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

    pastedimage1648427886789v1.png

    pastedimage1648427918757v2.png

  • chris197 Profile Picture
    chris197 50 on at
    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 Profile Picture
    YUN ZHU 73,696 Super User 2024 Season 2 on at
    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

    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

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans