PivotCacheDefinition Properties

Include Protected Members
Include Inherited Members

The PivotCacheDefinition type exposes the following members.

Properties

  Name Description
Public property BackgroundQuery Background Query.Represents the attribte in schema: backgroundQuery
Public property CacheFields PivotCache Fields.Represents the element tag in schema: x:cacheFields
Public property CacheHierarchies PivotCache Hierarchies.Represents the element tag in schema: x:cacheHierarchies
Public property CacheSource PivotCache Source Description.Represents the element tag in schema: x:cacheSource
Public property CalculatedItems Calculated Items.Represents the element tag in schema: x:calculatedItems
Public property CalculatedMembers Calculated Members.Represents the element tag in schema: x:calculatedMembers
Public property ChildElements Gets all the child nodes of this element. (Inherited from OpenXmlElement.)
Public property CreatedVersion PivotCache Created Version.Represents the attribte in schema: createdVersion
Public property Dimensions OLAP Dimensions.Represents the element tag in schema: x:dimensions
Public property EnableRefresh Enable PivotCache Refresh.Represents the attribte in schema: enableRefresh
Public property ExtendedAttributes Gets all extended attributes (attributes not defined in schema) of the element. (Inherited from OpenXmlElement.)
Public property FirstChild Gets the first child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.)
Public property HasAttributes Gets a boolean value indicating whether the current element has any attributes. (Inherited from OpenXmlElement.)
Public property HasChildren Gets a value indicating whether this element has any child elements. (Inherited from OpenXmlCompositeElement.)
Public property Id Relationship Identifier.Represents the attribte in schema: r:id
Public property InnerText Gets or sets the concatenated values of the node and all its children. (Inherited from OpenXmlCompositeElement.)
Public property InnerXml Gets or sets the markup representing only the child nodes of this node. (Inherited from OpenXmlCompositeElement.)
Public property Invalid Invalid Cache.Represents the attribte in schema: invalid
Public property IsTupleCache Stores Cache for OLAP Functions.Represents the attribte in schema: tupleCache
Public property Kpis OLAP KPIs.Represents the element tag in schema: x:kpis
Public property LastChild Gets the last child of the OpenXmlElement. If there is no such OpenXmlElement, a null reference (Nothing in Visual Basic) is returned. (Inherited from OpenXmlCompositeElement.)
Public property LastRefreshedDateIso refreshedDateIso, this property is only available in Office2010.Represents the attribte in schema: refreshedDateIso
Public property LocalName Gets the local name of the element. (Overrides OpenXmlElement.LocalName.)
Public property Maps OLAP Measure Group.Represents the element tag in schema: x:maps
Public property MCAttributes Markup Compatibility Attributes Set. Return null if there is no Markup Compatibility Attribute defined in this element. (Inherited from OpenXmlElement.)
Public property MeasureGroups OLAP Measure Groups.Represents the element tag in schema: x:measureGroups
Public property MinRefreshableVersion Minimum Version Required for Refresh.Represents the attribte in schema: minRefreshableVersion
Public property MissingItemsLimit Missing Items Limit.Represents the attribte in schema: missingItemsLimit
Public property NamespaceDeclarations Gets all the namespace declarations defined in the current element. Return an empty enumerator if there is no namespace declaration. (Inherited from OpenXmlElement.)
Public property NamespaceUri Gets the namespace URI of this node. (Inherited from OpenXmlElement.)
Public property OpenXmlElementContext Gets the OpenXmlEementContext. (Inherited from OpenXmlElement.)
Public property OptimizeMemory Optimize Cache for Memory.Represents the attribte in schema: optimizeMemory
Public property OuterXml Gets the markup representing this element and all its child elements. (Inherited from OpenXmlElement.)
Public property Parent Gets the parent of this element. (Inherited from OpenXmlElement.)
Public property PivotCacheDefinitionExtensionList Future Feature Data Storage Area.Represents the element tag in schema: x:extLst
Public property PivotTableCacheDefinitionPart Gets the PivotTableCacheDefinitionPart associated with this element.
Public property Prefix Gets the namespace prefix of this node. (Inherited from OpenXmlElement.)
Public property RecordCount PivotCache Record Count.Represents the attribte in schema: recordCount
Public property RefreshedBy Last Refreshed By.Represents the attribte in schema: refreshedBy
Public property RefreshedDate PivotCache Last Refreshed Date.Represents the attribte in schema: refreshedDate
Public property RefreshedVersion PivotCache Last Refreshed Version.Represents the attribte in schema: refreshedVersion
Public property RefreshOnLoad Refresh On Load.Represents the attribte in schema: refreshOnLoad
Public property SaveData Save Pivot Records.Represents the attribte in schema: saveData
Public property SupportAdvancedDrill Supports Attribute Drilldown.Represents the attribte in schema: supportAdvancedDrill
Public property SupportSubquery Supports Subqueries.Represents the attribte in schema: supportSubquery
Public property TupleCache Tuple Cache.Represents the element tag in schema: x:tupleCache
Public property UpgradeOnRefresh Upgrade PivotCache on Refresh.Represents the attribte in schema: upgradeOnRefresh
Public property XmlQualifiedName Gets the qualified name of the node. (Inherited from OpenXmlElement.)

Top

See Also

Reference

PivotCacheDefinition Class

DocumentFormat.OpenXml.Spreadsheet Namespace