Dimension class
OLAP Dimension. When the object is serialized out as xml, its qualified name is x:dimension.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Spreadsheet.Dimension
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
[ISO/IEC 29500-1 1st Edition]
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. [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. end example]
Parent Elements |
|---|
dimensions (§18.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 (§22.9.2.19). |
measure (Measure) | Specifies a boolean value that indicates whether this is a measure dimension. A value of 1 or true indicates this dimension is a measure dimension. A value of 0 or false indicates this dimension is not a measure dimension. The possible values for this attribute are defined by the W3C 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 (§22.9.2.19). |
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 (§22.9.2.19). |
[Note: The W3C XML Schema definition of this element’s content model (CT_PivotDimension) is located in §A.2. end note]
© ISO/IEC29500: 2008.