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.