<dimension> (OLAP Dimension)

Represents a PivotTable OLAP Dimension. A dimension is a field that organizes a single type of data into a hierarchy with levels of detail. For example, an OLAP database could contain a Time dimension providing data for levels Year, Month, Week, and Day, allowing you to create reports that let you compare day-to-day sales results or view a summary of your sales for an entire year.

Parent Elements

<dimensions> (§3.10.1.25)

Attributes

Description

<caption> (Dimension Display Name)

Specifies the display name of the dimension.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<measure> (Measure)

Specifies a boolean value that indicates whether this is a measure dimension.

A value of on, 1, or true indicates this dimension is a measure dimension.

A value of off, 0, or false indicates this dimension is not a measure dimension.

The possible values for this attribute are defined by the XML Schema boolean datatype.

<name> (Dimension Name)

Specifies the name of the dimension.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

<uniqueName> (Dimension Unique Name)

Specifies the unique name of the dimension.

The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_PivotDimension">
	<attribute name="measure" type="xsd:boolean" default="false"/>
	<attribute name="name" use="required" type="ST_Xstring"/>
	<attribute name="uniqueName" use="required" type="ST_Xstring"/>
	<attribute name="caption" use="required" type="ST_Xstring"/>
</complexType>