---
id: change/bcapps/12307
type: change
title: "#12307 Make UpgradeDefaultDimensions ParentId backfill set-based (via DataTransfer)"
summary: The UpgradeDefaultDimensions procedure now uses set-based DataTransfer operations instead of row-by-row processing to backfill ParentId fields in Default Dimension records, significantly reducing upgrade runtime on large tables.
tier: official
language: en
tags:
  - performance
  - main
  - bc30
  - codeunit upgrade - baseapp
system: platform
review:
  state: reviewed
  by: opus
  at: "2026-10-08T02:02:03.524Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-change: 1
  input_hash: a3a378ee9b95155b3add7a8a14f7690aff4c2cd3
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/pull/12307
    title: "microsoft/BCApps#12307: Make UpgradeDefaultDimensions ParentId backfill set-based (via DataTransfer)"
    date: "2026-10-05"
    commit: a3a378ee9b95155b3add7a8a14f7690aff4c2cd3
    t: null
    quote: Replace the loop with four set-based DataTransfer joins (Item, Customer, Vendor, Employee), consistent with the Parent Type / DimensionId steps in the same method.
links:
  learn: []
  objects:
    - object/codeunit/104000
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes: []
number: 12307
repo: microsoft/BCApps
source_id: bcapps-prs
url: https://github.com/microsoft/BCApps/pull/12307
kind: pr
base_branch: main
major: "30"
merged_at: "2026-10-05T20:34:50Z"
author: dcenic
author_type: User
community_contribution: false
labels:
  - "Ownership: Manual"
  - "Team: Finance"
change_class: code
change_kind: performance
behavior_change: false
breaking: false
files:
  count: 8
  additions: 224
  deletions: 72
  al: 8
apps:
  - Base Application
objects_touched:
  - key: codeunit/104000
    page: codeunit/104000
    type: codeunit
    id: 104000
    name: Upgrade - BaseApp
    app: Base Application
    status: modified
objects_unjoined: []
obsoletions: []
backports:
  - number: 12316
    base: releases/29.x
    url: https://github.com/microsoft/BCApps/pull/12316
fixes_issues: []
work_items:
  - 652937
systems:
  - platform
quote: Replace the loop with four set-based DataTransfer joins (Item, Customer, Vendor, Employee), consistent with the Parent Type / DimensionId steps in the same method.
joined_against:
  major: "30"
  commit: ecbc028c25dbe83b61313bc566e6c1d41184bb1c
---

# #12307 Make UpgradeDefaultDimensions ParentId backfill set-based (via DataTransfer)

> The UpgradeDefaultDimensions procedure now uses set-based DataTransfer operations instead of row-by-row processing to backfill ParentId fields in Default Dimension records, significantly reducing upgrade runtime on large tables.

[Pull request](https://github.com/microsoft/BCApps/pull/12307) · merged into `main` (BC30) on 2026-10-05 by dcenic · 8 files (+224 -72), 8 AL · performance · tier official · reviewed (checked by Opus)

## What changed

- Replaces per-row Get and Modify with four set-based DataTransfer joins (Item, Customer, Vendor, Employee)
- Destination rows are filtered by Table ID and blank ParentId so entity types cannot cross-match
- Behavior is preserved while upgrade runtime no longer grows with row count
- Applied in the W1, AT, BE, CH, IT, NL, NO and RU upgrade codeunits
- Audit fields are not restamped, consistent with the sibling DataTransfer steps

## AL objects touched

- [Codeunit 104000 "Upgrade - BaseApp"](../../objects/codeunit/104000.md), Base Application: modified

## Also merged into

- [#12316](https://github.com/microsoft/BCApps/pull/12316) into `releases/29.x` on 2026-10-06

## Context

- Work items: AB#652937
- Labels: Ownership: Manual, Team: Finance
- Systems: platform
- From the description: "Replace the loop with four set-based DataTransfer joins (Item, Customer, Vendor, Employee), consistent with the Parent Type / DimensionId steps in the same method."

Source: metadata of a merged pull request in microsoft/BCApps (bcapps): title, labels, changed paths and counts, with a summary in our words. No source text and no description beyond one short quote (D10, D61).