Dimension Class
OLAP Dimension.When the object is serialized out as xml, its qualified name is x:dimension.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Spreadsheet.Dimension
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
Public Class Dimension _
Inherits OpenXmlLeafElement
'Usage
Dim instance As Dimension
public class Dimension : OpenXmlLeafElement
Remarks
[ISO/IEC 29500-1 1st Edition]
18.10.1.24 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.
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.