Dimensions Class
OLAP Dimensions.When the object is serialized out as xml, its qualified name is x:dimensions.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.Dimensions
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<ChildElementInfoAttribute(GetType(Dimension))> _
Public Class Dimensions _
Inherits OpenXmlCompositeElement
'Usage
Dim instance As Dimensions
[ChildElementInfoAttribute(typeof(Dimension))]
public class Dimensions : OpenXmlCompositeElement
Remarks
The following table lists the possible child types:
- Dimension <x:dimension>
[ISO/IEC 29500-1 1st Edition]
18.10.1.25 dimensions (OLAP Dimensions)
Represents the collection of PivotTable OLAP dimensions.
[Example:
<dimensions count="22">
<dimension name="Account" uniqueName="[Account]" caption="Account"/>
<dimension name="Customer" uniqueName="[Customer]" caption="Customer"/>
<dimension name="Date" uniqueName="[Date]" caption="Date"/>
<dimension name="Delivery Date" uniqueName="[Delivery Date]"
caption="Delivery Date"/>
<dimension name="Department" uniqueName="[Department]" caption="Department"/>
<dimension name="Destination Currency" uniqueName="[Destination Currency]"
caption="Destination Currency"/>
<dimension name="Employee" uniqueName="[Employee]" caption="Employee"/>
<dimension name="Geography" uniqueName="[Geography]" caption="Geography"/>
<dimension name="Internet Sales Order Details" uniqueName="[Internet Sales
Order Details]" caption="Internet Sales Order Details"/>
<dimension measure="1" name="Measures" uniqueName="[Measures]"
caption="Measures"/>
<dimension name="Organization" uniqueName="[Organization]"
caption="Organization"/>
<dimension name="Product" uniqueName="[Product]" caption="Product"/>
<dimension name="Promotion" uniqueName="[Promotion]" caption="Promotion"/>
<dimension name="Reseller" uniqueName="[Reseller]" caption="Reseller"/>
<dimension name="Reseller Sales Order Details" uniqueName="[Reseller Sales
Order Details]" caption="Reseller Sales Order Details"/>
<dimension name="Sales Channel" uniqueName="[Sales Channel]" caption="Sales
Channel"/>
<dimension name="Sales Reason" uniqueName="[Sales Reason]" caption="Sales
Reason"/>
<dimension name="Sales Summary Order Details" uniqueName="[Sales Summary Order
Details]" caption="Sales Summary Order Details"/>
<dimension name="Sales Territory" uniqueName="[Sales Territory]"
caption="Sales Territory"/>
<dimension name="Scenario" uniqueName="[Scenario]" caption="Scenario"/>
<dimension name="Ship Date" uniqueName="[Ship Date]" caption="Ship Date"/>
<dimension name="Source Currency" uniqueName="[Source Currency]"
caption="Source Currency"/>
</dimensions>
end example]
Parent Elements |
|---|
pivotCacheDefinition (§18.10.1.67) |
Child Elements |
Subclause |
|---|---|
dimension (OLAP Dimension) |
§18.10.1.24 |
Attributes |
Description |
|---|---|
count (OLAP Dimensions Count) |
Specifies the number of OLAP dimensions in the PivotTable. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_Dimensions) 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.