Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_PivotCacheDefinition
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTable.xsd
Abstract
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_xsdXSD Diagram of CT_PivotCacheDefinition in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_PivotCacheDefinition">
    <xsd:sequence>
        <xsd:element name="cacheSource" type="CT_CacheSource" minOccurs="1" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>PivotCache Source Description</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="cacheFields" type="CT_CacheFields" minOccurs="1" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>PivotCache Fields</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="cacheHierarchies" minOccurs="0" type="CT_CacheHierarchies">
            <xsd:annotation>
                <xsd:documentation>PivotCache Hierarchies</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="kpis" minOccurs="0" type="CT_PCDKPIs">
            <xsd:annotation>
                <xsd:documentation>OLAP KPIs</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="tupleCache" minOccurs="0" type="CT_TupleCache">
            <xsd:annotation>
                <xsd:documentation>Tuple Cache</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="calculatedItems" minOccurs="0" type="CT_CalculatedItems">
            <xsd:annotation>
                <xsd:documentation>Calculated Items</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="calculatedMembers" type="CT_CalculatedMembers" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Calculated Members</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="dimensions" type="CT_Dimensions" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>OLAP Dimensions</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="measureGroups" type="CT_MeasureGroups" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>OLAP Measure Groups</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="maps" type="CT_MeasureDimensionMaps" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>OLAP Measure Group</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute ref="r:id" use="optional">
        <xsd:annotation>
            <xsd:documentation>Relationship Identifier</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="invalid" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Invalid Cache</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="saveData" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Save Pivot Records</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshOnLoad" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Refresh On Load</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="optimizeMemory" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Optimize Cache for Memory</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableRefresh" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Enable PivotCache Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshedBy" type="ST_Xstring" use="optional">
        <xsd:annotation>
            <xsd:documentation>Last Refreshed By</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshedDate" type="xsd:double" use="optional">
        <xsd:annotation>
            <xsd:documentation>PivotCache Last Refreshed Date</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="backgroundQuery" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Background Query</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="missingItemsLimit" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Missing Items Limit</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="createdVersion" type="xsd:unsignedByte" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>PivotCache Created Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="refreshedVersion" type="xsd:unsignedByte" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>PivotCache Last Refreshed Version</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minRefreshableVersion" type="xsd:unsignedByte" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Minimum Version Required for Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="recordCount" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>PivotCache Record Count</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="upgradeOnRefresh" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Upgrade PivotCache on Refresh</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="tupleCache" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Stores Cache for OLAP Functions</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="supportSubquery" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Supports Subqueries</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="supportAdvancedDrill" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Supports Attribute Drilldown</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
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:
Collapse References:
nsM:pivotCacheDefinition
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0