[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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

dimensions3.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>