MultiLevel Hierarchy
This is the classical way of defining OLAP hierarchies. This type allows you to define a hierarchy where each level is defined with a table column. The member name is mapped with a column, member key can be defined with several columns.
Walkthrough
We're going to use a little walkthrough to explain how to create a multi-level dimension. First, we need to define our data. For the sake of simplicity we're going to use the geography dimension with a few members:
Continent , Country, Country_ID
Europe , France , FR
America , United States , US
America , Canada , CA
America , Mexico , MX
1) Let's create an In-Memory data source and create a table with our data
2) Once the data is defined, we can begin to build our multi-level dimension, let's called it 'Geography'
3) We will create a single hierarchy for our dimension. This hierarchy will have two levels, Continent and Country. Both matching the columns we defined in our table (note we order the members by name).
And this is all we need to define our simple [Geography] dimension. We can now check the results on the dimension browser:
Next chapter: MultiLevel Hierarchy Advanced