OLAP Server User Guide
MDX Documentation
MDX Functions Reference

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.


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

OLAP data source (Geography)

2) Once the data is defined, we can begin to build our multi-level dimension, let's called it 'Geography'

OLAP Multilevel dimension

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).

OLAP Multilevel dimension

And this is all we need to define our simple [Geography] dimension. We can now check the results on the dimension browser:

OLAP Multilevel dimension

Next chapter: MultiLevel Hierarchy Advanced