Hi,
I was trying to create the DIM Geography using listed in Adventures Works DW and when I deploy this the browser will show me so many Country names as shown in the below screenshot
After worrying my head a lot on this issue, I realised that this happened as I had set key column even for EnglishCountryRegion name. Hence to resolve this issue, I came back to "Dimension Structure" tab>right click on "English Country Region Name">Click on properties>Come to "Keycolumn" and remove any other attributes added and make the EnglishCountryRegionName to be uinque. Check the below fig
Deploy and then reconnect to get the final result
I was trying to create the DIM Geography using listed in Adventures Works DW and when I deploy this the browser will show me so many Country names as shown in the below screenshot
After worrying my head a lot on this issue, I realised that this happened as I had set key column even for EnglishCountryRegion name. Hence to resolve this issue, I came back to "Dimension Structure" tab>right click on "English Country Region Name">Click on properties>Come to "Keycolumn" and remove any other attributes added and make the EnglishCountryRegionName to be uinque. Check the below fig
Deploy and then reconnect to get the final result
No comments:
Post a Comment