There are some dimensions that are in almost all cubes, for example DimTime. If our cube handles HR data or Logistic data most probably will have also a DimCountry. This dimension normally contains fields like CountryName, Region, etc. A field that is not that quiet normal to have is “Geometry” (or some other name). This field has the shape for the country in SQL Server 2008 (Compatibility level 100) in case that you would like to create a map with the countries.
So, I decided to share with all of you a DimCountry dimension that contains a “Geometry” field among few others that could be useful to you. The list is not 100% complete, but the main countries are there with their shape.
Download a .zip file containing a backup of a database with the DimCountry table here: https://drive.google.com/folderview?id=0B-h7xyFxWnh0b1hIaXk0UnNxRUk&usp=sharing