Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / What are these columns...
Small and medium business | Business Central, N...
Suggested answer

What are these columns for in configuration package for Dimensions?

(1) ShareShare
ReportReport
Posted on by joshtechsolutions 4,401
Hi Community,
 
In configuration package when I export the dimensions I see these 3 columns, may I know what do these do ?
 
I wonder if I change the dimensions, do I need to import these columns as well.
 
Thank you.
Categories:
Microsoft Dynamics NAV
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 12,546 Most Valuable Professional on at
    What are these columns for in configuration package for Dimensions?

    Hi, good day
    I hope this can help you, and give you some hints.

    Design Details - Table Structure - Business Central | Microsoft Learn

    Table "Dimension Set Tree Node" | Microsoft Learn

    Best Regards
    Gerardo

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,961 Super User 2024 Season 2 on at
    What are these columns for in configuration package for Dimensions?
    As mentioned you can either not include these fields in the configuration package, or if you included them, you can simply leave them blank.
     
  • Suggested answer
    Inkey Solutions Profile Picture
    Inkey Solutions 1,758 on at
    What are these columns for in configuration package for Dimensions?
    In Business Central, the fields Parent ID, Dimension ID, and Dimension Value ID are primarily used to manage dimensions and their values for categorizing and analyzing financial data. These fields are also used in Configuration Packages to import, export, and map dimension data efficiently during data migration or setup processes.

    When you export data without filtering the table fields, the system includes all columns in the exported file. However, these fields are not always necessary when importing data using a Configuration Package. You can either leave these columns empty (without any values) or exclude them from the exported sheet by filtering the table fields before exporting.

    you can select the necessary fields you want and export it using this option:
     
     
    Here, you only need to check the necessary fields in the Configuration Package so that only those fields are included in the export sheet.
     
     
    This way, you won't have to enter data or leave the column blank unnecessarily.
     
     
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 5,234 on at
    What are these columns for in configuration package for Dimensions?
    The columns ParentId, DimensionId, and DimensionValueId in the configuration package for Dimensions are system-generated GUIDs used to maintain the hierarchy (ParentId), uniquely identify dimensions (DimensionId), and their values (DimensionValueId). You generally don’t need to import or modify them unless you're dealing with specific cases like maintaining links during migrations or updates.

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,503 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans