Definition Type: Element
Name: pivotCacheDefinition
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_PivotCacheDefinition
Containing Schema: sml-pivotTable.xsd
Abstract
Documentation:
PivotCache Definition
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottable_xsd Drilldown into maps in schema sml-pivottable_xsd Drilldown into measureGroups in schema sml-pivottable_xsd Drilldown into dimensions in schema sml-pivottable_xsd Drilldown into calculatedMembers in schema sml-pivottable_xsd Drilldown into calculatedItems in schema sml-pivottable_xsd Drilldown into tupleCache in schema sml-pivottable_xsd Drilldown into kpis in schema sml-pivottable_xsd Drilldown into cacheHierarchies in schema sml-pivottable_xsd Drilldown into cacheFields in schema sml-pivottable_xsd Drilldown into cacheSource in schema sml-pivottable_xsd Drilldown into supportAdvancedDrill in schema sml-pivottable_xsd Drilldown into supportSubquery in schema sml-pivottable_xsd Drilldown into tupleCache in schema sml-pivottable_xsd Drilldown into upgradeOnRefresh in schema sml-pivottable_xsd Drilldown into recordCount in schema sml-pivottable_xsd Drilldown into minRefreshableVersion in schema sml-pivottable_xsd Drilldown into refreshedVersion in schema sml-pivottable_xsd Drilldown into createdVersion in schema sml-pivottable_xsd Drilldown into missingItemsLimit in schema sml-pivottable_xsd Drilldown into backgroundQuery in schema sml-pivottable_xsd Drilldown into refreshedDate in schema sml-pivottable_xsd Drilldown into refreshedBy in schema sml-pivottable_xsd Drilldown into enableRefresh in schema sml-pivottable_xsd Drilldown into optimizeMemory in schema sml-pivottable_xsd Drilldown into refreshOnLoad in schema sml-pivottable_xsd Drilldown into saveData in schema sml-pivottable_xsd Drilldown into invalid in schema sml-pivottable_xsd Drilldown into id in schema shared-relationshipreference_xsd Drilldown into CT_PivotCacheDefinition in schema sml-pivottable_xsdXSD Diagram of pivotCacheDefinition in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:element name="pivotCacheDefinition" type="CT_PivotCacheDefinition">
    <xsd:annotation>
        <xsd:documentation>PivotCache Definition</xsd:documentation>
    </xsd:annotation>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
cacheSource nsM:cacheSource 1 1
cacheFields nsM:cacheFields 1 1
cacheHierarchies nsM:cacheHierarchies 0 (1)
kpis nsM:kpis 0 (1)
tupleCache nsM:tupleCache 0 (1)
calculatedItems nsM:calculatedItems 0 (1)
calculatedMembers nsM:calculatedMembers 0 (1)
dimensions nsM:dimensions 0 (1)
measureGroups nsM:measureGroups 0 (1)
maps nsM:maps 0 (1)
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
id r:id Optional
invalid nsM:invalid false Optional
saveData nsM:saveData true Optional
refreshOnLoad nsM:refreshOnLoad false Optional
optimizeMemory nsM:optimizeMemory false Optional
enableRefresh nsM:enableRefresh true Optional
refreshedBy nsM:refreshedBy Optional
refreshedDate nsM:refreshedDate Optional
backgroundQuery nsM:backgroundQuery false (Optional)
missingItemsLimit nsM:missingItemsLimit Optional
createdVersion nsM:createdVersion 0 Optional
refreshedVersion nsM:refreshedVersion 0 Optional
minRefreshableVersion nsM:minRefreshableVersion 0 Optional
recordCount nsM:recordCount Optional
upgradeOnRefresh nsM:upgradeOnRefresh false Optional
tupleCache nsM:tupleCache false Optional
supportSubquery nsM:supportSubquery false Optional
supportAdvancedDrill nsM:supportAdvancedDrill false Optional
Collapse Derivation Tree: