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

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

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

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