LevelCount

LevelCount returns the number levels in a dimension.

This function is valid in both rules and TurboIntegrator processes.

Syntax

LevelCount(dimension, hierarchy)

Argument

Description

dimension

A valid dimension name.

Some installations may need to qualify the dimension name with the database name, as in database_name:dimension.

hierarchy

The name of the hierarchy within the dimension.

Example

LevelCount('Region', 'Countries')

In the Region dimension, the various nations (Level 0) add up to regions (Level 1). The regions then add up to super-regions (Level 2), which in turn add up to the world (Level 3).

There are four levels in the Region dimension, so the example returns the value 4.