dim_level - Dimension level

When using data type members as dimension in an aggregation schema, a level may be defined for the dimension. By default, the dimension level is assumed to be 1. In order to define aggregation levels e.g. for DATE (year/month/day) the level number has to be set to 3. Implicit levels are also defined for TIME (hour/minute/second/hundredth second) and DATETIME.

User-defined levels require a level function, which returns the key value for each level. Hierarchical classifications deliver dimension values according to the category hierarchy level.