What are these columns for in configuration package for Dimensions?

(1) Share

Report

Posted on by joshtechsolutions

4,947

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Khushbu Rajvi. 19,160 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Inkey Solutions 2,086 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,792 Super User 2025 Season 2 on at

Like (0)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 23,574 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No