[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 |
|
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>