# Level

Base element for level elements within a hierarchy.

### Description

The Level is an abstract element that defines the basic properties of a OLAP level element. It has two derived classes, one is tabular level and another is ODA level.

Level is the real element which defined the column expression from the dataset. You can set sort, filter, TOC on the level. The column expression defined on the level could be dynamic reference to a dataset, also it could be static that user defined on the level by a value list.

### See Also

## dataType

Level data type property.

### Description

This property gives out the data type of the level resulting data.

### See Also

## dateTimeLevelType

Date time type.

### Choices

- month
- quarter
- week-of-year
- week-of-month
- day-of-year
- day-of-month
- day-of-week
- hour
- minute
- second

### Description

This property specifies the detail type if the level is date time. This is used to speed up the performance.

### See Also

## dateTimeFormat

Date time format applied on this level element.

### Description

This property defines how to format the value if the data type of the level is date time.It contains the format pattern, category and locale. If the the data type of the level is date time and you don't set this property, the output is the general string calling toString method in Object.

### See Also

## intervalBase

In conjunction with Interval and IntervalRange, determines how data is divided into groups.

### Description

In conjunction with Interval and IntervalRange, determines how data is divided into groups.

## interval

When creating intervals, this property allows grouping on a range of contiguous values.

### Choices

- none: Group on individual values.
- prefix: Group on a string prefix
- interval: Group on a numeric interval.

### Description

This property allows the level element to include a range of contiguous values. For example, a monthly sales report may want to summarize a list of individual transactions, each of which has a transaction date. Using the Month interval, BIRT will cause a break to occur each time the transaction dates move into a different calendar month.

Use this property with the `intervalRange` property to select a set of contiguous values. For example, a bi-monthly report would use the Month `interval` with an `intervalRange` of 2.

### See Also

`intervalRange` Property

## intervalRange

Number of contiguous groups to merge to create a single group.

### Description

When creating intervals, this attribute allows grouping on a range of contiguous values. For example, to show data over the span of three hours, set the grouping interval to hours and the range to 3. The user enters the interval range here.

The following shows the meaning of the range for each interval type.

Interval | Meaning of Range
None | Ignored
Prefix | The number of characters in the prefix.
Date/Time | The number of the units.
Interval | The numeric interval

### See Also

`interval` Property

### See Also

## levelType

Type of the level.

### Choices

- dynamic:get the query result from data base directly
- mirrored: get the query result from the data base and then do some mirror handling

### Description

This property indicates whether this level is dynamic or mirrored. If the level is dynamic, you can define a list of level attribute on it to do filter operation on the query result from data base. If the level is mirrored, you can define a list of rules as static values to do mirroring and set an BIRT expression as the default value, which is used as default during mirroring.

### See Also

## staticValues

Series of rules applied on this level.

### Description

This property defines a list of rules. If the level type is mirrored, you can add a list of rule structures as the static values to do mirroring.

### See Also

## defaultValue

Default value expression applied on this level.

### Description

This property defines.

### See Also