Creating Levels

Levels are used to set up data aggregation in a cube which uses MDM dictionary as a dimension.

Aggregation is the calculation of data of the top level based on the data of the bottom level. For example, calculated monthly data are summed to obtain quarterly data.

Suppose the MDM dictionary has the following element hierarchy:

• North America:

• • Canada.

  • USA.

• South America:

• • Mexico.

  • Peru.

  • Chile.

Create two levels for these elements:

• Continents.

• States.

NOTE. Each new level must correspond to the actual level of the MDM dictionary elements hierarchy.

If this dictionary is used as a cube dimension, aggregation can be set up. For example, values for the states can be summed up to get values for the whole continent.

To create and set up dictionary levels, use the Levels tab.

Operations with Levels

Add level

Edit level name

Delete level

See also:

Setting Up Dictionary Structure | Working with Dictionary Elements | Questions and Answers