Documentation

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:

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: