Creating Levels

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

Aggregation is calculation of data of the upper level based on the data of the lower level. For example, calculated monthly data is summed to get quarterly data.

Suppose that an MDM dictionary has the following elements hierarchy:

• North America:

• • Canada.

  • USA.

• South America:

• • Mexico.

  • Peru.

  • Chile.

Create two levels for these elements:

• Continents.

• States.

NOTE. Each created 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 a level

Edit level name

Delete level

See also:

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