2.1.23 TPropertyStatistics

  • Article

In CSDLBI 2.0 and CSDLBI 2.5, the TPropertyStatistics complex type defines statistics that are computed over the data that is associated with a column.

Statistics are provided only if the computation is not prevented by use of certain advanced product features such as dimension security, row-level security, and columns with non-ordered attribute hierarchies. Because statistics are not provided if they are computationally expensive to generate, the response is not guaranteed to include statistics.

The TPropertyStatistics complex type is defined in the schema as follows.

 <xs:complexType name="TPropertyStatistics">
   <xs:sequence>
     <xs:element name="MinValue" type="xs:anyType" minOccurs="0" maxOccurs="1" />
     <xs:element name="MaxValue" type="xs:anyType" minOccurs="0" maxOccurs="1" />
   </xs:sequence>
   <xs:attribute name="DistinctValueCount" type="xs:long" use="optional" />
   <xs:attribute name="StringValueMaxLength" type="xs:long" use="optional" />
 </xs:complexType>

The elements and attributes that are defined by the TPropertyStatistics complex type are specified in the following tables.

Element

Description

MinValue

The smallest data value present in the column. The type of this value varies to match the data type of the column. Note that the ordering of values in the column is based on the attribute hierarchy for the column.

MaxValue

The largest data value present in the column. The type of this value varies to match the data type of the column. Note that the ordering of values in the column is based on the attribute hierarchy for the column.

Attribute

Description

DistinctValueCount

The number of unique values present in the column.

StringValueMaxLength

An upper bound on the maximum length of any string value in the column. Note that this value can be larger than the longest string length but cannot be shorter than the longest string length.