Target state once the MDM Spain changes are complete. As Is state: Dimension Source Mappings — As Is. Rows highlighted green change meaning under Change 2 (title = local divisions); the mapping paths themselves are unchanged.
Department
Target design: Department and Central Department are the same, both as they are in D365. Local Department is the local department name from the MDM mapping table.
| DIM.Department View | DIM.DimDepartment Table | staging.department View (Silver LH) | Source Table.Column | Comments |
|---|---|---|---|---|
SKDepartmentID |
SKDepartmentID |
n/a | n/a | Surrogate key, generated in load.usp_dimdepartment (max existing + row_number). |
RecID |
RecID |
recid |
dirpartytable.recid |
The department party record, reached via dimensionattributevaluecombination.department. |
Department Code - Name |
derived | n/a | n/a | Built in the DIM view as DepartmentCode + ' - ' + LocalDepartment. |
Department Code |
DepartmentCode |
departmentcode |
dimensionattributevaluecombination.departmentvalue |
The Department financial dimension value. |
Department |
Department |
department |
dirpartytable.name |
Changes from As Is. Now the D365 name, same as Central Department (was the MDM local name). |
Central Department |
Department |
department |
dirpartytable.name |
Same as Department, as in D365. |
Local Department |
LocalDepartment |
localdepartment |
svsmasterdimensionmapping.dream_dept |
MDM. Local department name, matched on department code + company code. |
CompanyCode |
CompanyCode |
companycode |
dirpartytable.dataarea |
|
Country |
Country |
country |
logisticsaddresscountryregiontranslation.shortname |
Division
Target design: Division and Central Division are the same, both the D365 Division dimension name looked up from the MDM division code. Local Division is the local division name from the MDM mapping table (title, after Change 2).
| DIM.Division View | DIM.DimDivision Table | staging.division View (Silver LH) | Source Table.Column | Comments |
|---|---|---|---|---|
SKDivisionID |
SKDivisionID |
n/a | n/a | Surrogate key, generated in load.usp_dimdivision. |
RecID |
RecID |
recid |
svsmasterdimensionmapping.recid |
MDM row id. |
Division Code |
DivisionCode |
divisioncode |
svsmasterdimensionmapping.division |
|
Division |
Division |
division |
dimensionfinancialtag.description |
Changes from As Is. D365 Division dimension name for the MDM division code (was MDM title). |
Central Division |
Division |
division |
dimensionfinancialtag.description |
New. Same as Division. |
Local Division |
LocalDivision |
localdivision |
svsmasterdimensionmapping.title |
MDM. Local division name, held in title after Change 2. |
Company Code |
CompanyCode |
companycode |
svsmasterdimensionmapping.dataareaid |