Path hierarchies allow us to define a hierarchy with a single column. In this column the different levels are concatenated using a separator. This can be used for example to convert a Java/C# class path into a hierarchical structure.
Let's use the same simple dimension data we used in our former examples. We define our basic geography structure with a couple of countries.
name Europe.France America.United States America.Canada America.Mexico
1) After creating the new table, defining the [Geography] dimension is just a few steps away:
2) And this is all we need to define our simple [Geography] dimension. We can now check the results on the dimension browser:
Next chapter: Ranged Dimension (Banded)