TCubeDim.BinType Property

Indicates how the values of the field represented by the dimension are grouped.

Pascal

property BinType: TBinType;

C++

__property TBinType BinType;

Description

Set BinType to restrict the values that appear along the dimension. BinType can have one of the following values:

Value	Meaning
binNone	All values along the dimension appear.
binYear	Each cell along the dimension represents all field values that represent dates from the same year.
binQuarter	Each cell along the dimension represents all field values that represent dates from the same quarter.
binMonth	Each cell along the dimension represents all field values that represent dates from the same month.
binSet	The dimension is in a paged (permanently drilled) state. The drill-down value of the dimension can be changed, but the dimension can not be opened or closed.
binCustom	binCustom is not currently used but is provided to allow component writers to support other types of ranges.

If BinType is binYear, binQuarter, or binMonth, use the BinFormat property to indicate how the values of the ranges along the dimension should be formatted.

If BinType is binSet, use the StartValue property to specify which value along the dimension is used as the drill-down value. Unlike the drill-down value of a normal dimension, which is part of the pivot state stored by the decision source, the drill-down value of a paged dimension is the only value cached by the decision cube. Changing the drill-down value of paged dimensions causes the decision cube to rebuild its cache, which can be very time-consuming.

Note: When BinType is binSet, the dimension item consumes considerably less memory in the decision cube.

Note: Do not set BinType to binYear, binQuarter, or binMonth if the dimension does not represent a date or date-time field.