---
title: "Converting the Dimension Set ID with DataMigrate Pro"
id: "997948"
type: "post"
slug: "dimension-set-id-conversion-with-datamigrate-pro"
published_at: "2025-09-12T12:41:42+00:00"
modified_at: "2026-09-02T06:07:08+00:00"
url: "https://ioi.gmbh/en/2025/09/12/dimension-set-id-conversion-with-datamigrate-pro/"
markdown_url: "https://ioi.gmbh/en/2025/09/12/dimension-set-id-conversion-with-datamigrate-pro.md"
excerpt: "Not all older NAV versions have the Dimension Set ID field. If you want to fill this field in the target system, a small entry in the migration configuration is enough. The list of tables to be migrated contains the..."
taxonomy_category:
  - "DataMigrate Pro"
  - "Support & Documentation"
---

Not all old NAV versions have the **Dimension Set ID** field. If you want to fill this field in the target system, a small entry in the migration configuration is enough.

The list of tables to be migrated contains the field **Dimension Set ID Field No.** If one is specified in the configuration, DataMigrate Pro adjusts the data query. Beforehand, however, a list of the dimension usages per table has to be determined. To do this you first open the form or page **BC Dimensions** and start the analysis which among other things Action

If we want the Dimension Set ID to be set for table 17, for example, the corresponding field number 480 must be entered in the overview.

This adjustment ensures that the correct Dimension Set ID is stored in Business Central.

For visitors interested in the technology – here is the generated SQL command:

```
;WITH T AS 
(
  SELECT ROW_NUMBER() OVER(ORDER BY T.[Entry No_]) [RowNumber]
       , T.[Entry No_]
	   , T.[G_L Account No_]
	   , ...
    FROM [Demo Database NAV (6-0)].dbo.[CRONUS AG$G_L Entry] T WITH (NOLOCK)
)
, D AS
(  
SELECT T.[Entry No_]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='BEREICH' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(BEREICH)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='DEBITORENGRUPPE' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(DEBITORENGRUPPE)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='EINKÄUFER' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(EINKÄUFER)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='KOSTENSTELLE' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(KOSTENSTELLE)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='KOSTENTRÄGER' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(KOSTENTRÄGER)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='UNTERNEHMENSGRUPPE' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(UNTERNEHMENSGRUPPE)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='VERKÄUFER' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(VERKÄUFER)]       
      , MAX(COALESCE(CASE WHEN [Dimension Code]='VERKAUFSKAMPAGNE' THEN [Dimension Value Code] ELSE '' END,'')) [DimensionValue(VERKAUFSKAMPAGNE)]    
   FROM [Demo Database NAV (6-0)].dbo.[CRONUS AG$Ledger Entry Dimension] TGROUP BY T.[Entry No_]
)
 SELECT T.*, [DimensionValue(BEREICH)]
       ,[DimensionValue(DEBITORENGRUPPE)]
       ,[DimensionValue(EINKÄUFER)]
       ,[DimensionValue(KOSTENSTELLE)]
       ,[DimensionValue(KOSTENTRÄGER)]
       ,[DimensionValue(UNTERNEHMENSGRUPPE)]
       ,[DimensionValue(VERKÄUFER)]
       ,[DimensionValue(VERKAUFSKAMPAGNE)]
       , 0 [Type_of_Change] 
    FROM T   
    JOIN D ON T.[Entry No_]=D.[Entry No_] 
   WHERE T.[RowNumb....
```

About the author

#### Sascha Marquardt

Responsible for the partner programme, the licensing business and commercial project delivery.

Keep reading## More from the IOI blog

[DataMigrate Pro DataMigrate PRO Synch-Service Setting up and running the service bus listener as a Windows service – from the prerequisites to settings.json 24. October 2025 · 4 minutes](https://ioi.gmbh/en/2025/10/24/datamigrate-pro-synch-service/)
[DataMigrate Pro Working with Configuration Data Six ways to move configurations between Business Central, the local installation and a ZIP archive – with the matching commands 23. October 2025 · 2 minutes](https://ioi.gmbh/en/2025/10/23/working-with-configuration-data/)
[DataMigrate Pro Step-by-Step Guide for the Migration to Business Central From the AppSource install to the first migration run – the complete DataMigrate Pro sequence 9. October 2025 · 3 minutes](https://ioi.gmbh/en/2025/10/09/step-by-step-guide-migration-to-business-central/)

## From reading to action. Book your upgrade check.

In the free upgrade check we analyse your current Navision or NAV version and show you the direct path to Business Central – including effort, sequence and a fixed-price range.

[Book a free Upgrade-Check →](/en/business-central-upgrade-check/)
[Give us a quick call: +49 214 8402 3000](tel:+4921484023000)

✓ Directly from any Navision or NAV version

✓ Live test while the legacy system keeps running

✓ C/AL→AL conversion included

✓ Fixed-price range and timeline afterwards