Mapping Help

[#1]

Hi All,

Greetings for the day.

I have 3 tables Fact, Dim1, Dim2.

Fact table contains BCode,Pcode,Amount

Dim1 contains BCode,Unit

Dim2 contains PCode,Region,Country

My requirement is if i select Unit = Unit2 and Country = Thailand then my actual Region = Asia

But as per my req i need to show( or Mapping) if i select Unit = Unit2 and Country = Thailand then Region = China

Could you please somebody help me here?

Thanks,

QV 11 User

[#2]

Hi, on what basis you need mapping ? its on country base or existing region base.

Create Inline Mapping or excel file to convert existing region name to new region name based Mapping conditions & use ApplyMap to add new field to data model.