The "KH Region Name" is visible on SSAS_KMN data cube



This field is pulling records from table [MatrixData].dbo.[Dim_KHSalespersonRegion]. So in case you are requested to enter/update the region name for a specific salesperson ID, you can use the following code:


USE [MatrixData]

GO

 

INSERT INTO [dbo].[Dim_KHSalespersonRegion]([Salesperson],[Region name]) VALUES ('H836','Asia+Pacific')

INSERT INTO [dbo].[Dim_KHSalespersonRegion]([Salesperson],[Region name]) VALUES ('H833','Asia+Pacific')

INSERT INTO [dbo].[Dim_KHSalespersonRegion]([Salesperson],[Region name]) VALUES ('H831','Asia+Pacific')