Dim Country

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

Tagged with:
Posted in SSAS
2 comments on “Dim Country
  1. Fred says:

    Damned dimCountry file is not available anymore

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other followers

%d bloggers like this: