Docs for schema sml-pivotTable.xsd in Office Open XML (OOXML / OpenXML / Ecma 376)

Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Schema Name:	sml-pivotTable.xsd
Target Namespace:	http://schemas.openxmlformats.org/spreadsheetml/2006/main
XSD Schema Code:

<xsd:schema targetNamespace="http://schemas.openxmlformats.org/spreadsheetml/2006/main" elementFormDefault="qualified" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">
  <xsd:include schemaLocation="sml-baseTypes.xsd" />
  <xsd:include schemaLocation="sml-styles.xsd" />
  <xsd:include schemaLocation="sml-sheet.xsd" />
  <xsd:include schemaLocation="sml-pivotTableShared.xsd" />
  <xsd:include schemaLocation="sml-autoFilter.xsd" />
  <xsd:import namespace="http://schemas.openxmlformats.org/officeDocument/2006/relationships" schemaLocation="shared-relationshipReference.xsd" />
  <xsd:element name="pivotCacheDefinition" type="CT_PivotCacheDefinition">
    <xsd:annotation>
      <xsd:documentation>PivotCache Definition</xsd:documentation>
    </xsd:annotation>
  </xsd:element>
  <xsd:element name="pivotCacheRecords" type="CT_PivotCacheRecords">
    <xsd:annotation>
      <xsd:documentation>PivotCache Records</xsd:documentation>
    </xsd:annotation>
  </xsd:element>
  <xsd:element name="pivotTableDefinition" type="CT_pivotTableDefinition">
    <xsd:annotation>
      <xsd:documentation>PivotTable Definition</xsd:documentation>
    </xsd:annotation>
  </xsd:element>
  <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>
  <xsd:complexType name="CT_CacheFields">
    <xsd:sequence>
      <xsd:element name="cacheField" type="CT_CacheField" minOccurs="0" maxOccurs="unbounded">
        <xsd:annotation>
          <xsd:documentation>PivotCache Field</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CacheField">
    <xsd:sequence>
      <xsd:element name="sharedItems" type="CT_SharedItems" minOccurs="0" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Shared Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="fieldGroup" minOccurs="0" type="CT_FieldGroup">
        <xsd:annotation>
          <xsd:documentation>Field Group Properties</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="mpMap" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Properties Map</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 name="name" type="ST_Xstring" use="required">
      <xsd:annotation>
        <xsd:documentation>PivotCache Field Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>PivotCache Field Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="propertyName" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Property Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="serverField" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Server-based Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueList" type="xsd:boolean" use="optional" default="true">
      <xsd:annotation>
        <xsd:documentation>Unique List Retrieved</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional">
      <xsd:annotation>
        <xsd:documentation>Number Format Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formula" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Calculated Field Formula</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sqlType" type="xsd:int" use="optional" default="0">
      <xsd:annotation>
        <xsd:documentation>SQL Data Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hierarchy" type="xsd:int" use="optional" default="0">
      <xsd:annotation>
        <xsd:documentation>Hierarchy</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="level" type="xsd:unsignedInt" use="optional" default="0">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Level</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="databaseField" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Database Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mappingCount" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="memberPropertyField" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Member Property Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CacheSource">
    <xsd:choice minOccurs="0" maxOccurs="1">
      <xsd:element name="worksheetSource" type="CT_WorksheetSource" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Worksheet PivotCache Source</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="consolidation" type="CT_Consolidation" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Consolidation Source</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:choice>
    <xsd:attribute name="type" type="ST_SourceType" use="required">
      <xsd:annotation>
        <xsd:documentation>Cache Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="connectionId" type="xsd:unsignedInt" default="0" use="optional">
      <xsd:annotation>
        <xsd:documentation>Connection Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:simpleType name="ST_SourceType">
    <xsd:annotation>
      <xsd:documentation>PivotCache Type</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="worksheet">
        <xsd:annotation>
          <xsd:documentation>Worksheet</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="external">
        <xsd:annotation>
          <xsd:documentation>External</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="consolidation">
        <xsd:annotation>
          <xsd:documentation>Consolidation Ranges</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="scenario">
        <xsd:annotation>
          <xsd:documentation>Scenario Summary Report</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:complexType name="CT_WorksheetSource">
    <xsd:attribute name="ref" type="ST_Ref" use="optional">
      <xsd:annotation>
        <xsd:documentation>Reference</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Named Range</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sheet" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Sheet Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute ref="r:id" use="optional">
      <xsd:annotation>
        <xsd:documentation>Relationship Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Consolidation">
    <xsd:sequence>
      <xsd:element name="pages" type="CT_Pages" minOccurs="0" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Page Item Values</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="rangeSets" type="CT_RangeSets" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Range Sets</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="autoPage" type="xsd:boolean" default="true" use="optional">
      <xsd:annotation>
        <xsd:documentation>Auto Page</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Pages">
    <xsd:sequence>
      <xsd:element name="page" type="CT_PCDSCPage" minOccurs="1" maxOccurs="4">
        <xsd:annotation>
          <xsd:documentation>Page Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Page Item String Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PCDSCPage">
    <xsd:sequence>
      <xsd:element name="pageItem" type="CT_PageItem" minOccurs="0" maxOccurs="unbounded">
        <xsd:annotation>
          <xsd:documentation>Page Item</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Page Item String Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PageItem">
    <xsd:attribute name="name" type="ST_Xstring" use="required">
      <xsd:annotation>
        <xsd:documentation>Page Item Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_RangeSets">
    <xsd:sequence>
      <xsd:element name="rangeSet" type="CT_RangeSet" minOccurs="1" maxOccurs="unbounded">
        <xsd:annotation>
          <xsd:documentation>Range Set</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Reference and Page Item Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_RangeSet">
    <xsd:attribute name="i1" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Field Item Index Page 1</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i2" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Field Item Index Page 2</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i3" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Field Item index Page 3</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i4" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Field Item Index Page 4</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="ref" type="ST_Ref" use="optional">
      <xsd:annotation>
        <xsd:documentation>Reference</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Named Range</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sheet" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Sheet Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute ref="r:id" use="optional">
      <xsd:annotation>
        <xsd:documentation>Relationship Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_SharedItems">
    <xsd:choice minOccurs="0" maxOccurs="unbounded">
      <xsd:element name="m" type="CT_Missing" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>No Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="n" type="CT_Number" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Numeric</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="b" type="CT_Boolean" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Boolean</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="e" type="CT_Error" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Error Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="s" type="CT_String" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Character Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="d" type="CT_DateTime" minOccurs="1" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Date Time</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:choice>
    <xsd:attribute name="containsSemiMixedTypes" type="xsd:boolean" use="optional" default="true">
      <xsd:annotation>
        <xsd:documentation>Contains Semi Mixed Data Types</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsNonDate" type="xsd:boolean" use="optional" default="true">
      <xsd:annotation>
        <xsd:documentation>Contains Non Date</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsDate" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Contains Date</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsString" type="xsd:boolean" use="optional" default="true">
      <xsd:annotation>
        <xsd:documentation>Contains String</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsBlank" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Contains Blank</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsMixedTypes" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Contains Mixed Data Types</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsNumber" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Contains Numbers</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="containsInteger" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Contains Integer</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minValue" type="xsd:double" use="optional">
      <xsd:annotation>
        <xsd:documentation>Minimum Numeric Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="maxValue" type="xsd:double" use="optional">
      <xsd:annotation>
        <xsd:documentation>Maximum Numeric Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minDate" type="xsd:dateTime" use="optional">
      <xsd:annotation>
        <xsd:documentation>Minimum Date Time</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="maxDate" type="xsd:dateTime" use="optional">
      <xsd:annotation>
        <xsd:documentation>Maximum Date Time Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="count" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Shared Items Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="longText" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Long Text</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Missing">
    <xsd:sequence>
      <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>Tuples</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Property Indexes</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="u" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unused Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Calculated Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cp" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="in" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Format Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>background Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>Foreground Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Italic</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Underline</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Strikethrough</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Bold</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Number">
    <xsd:sequence>
      <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>OLAP Members</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Property Index</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="v" use="required" type="xsd:double">
      <xsd:annotation>
        <xsd:documentation>Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="u" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unused Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Calculated Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cp" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="in" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Format Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>Background Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>Foreground Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Italic</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Underline</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Strikethrough</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Bold</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Boolean">
    <xsd:sequence>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Property Indexes</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="v" use="required" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="u" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unused Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Calculated Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cp" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Error">
    <xsd:sequence>
      <xsd:element name="tpls" minOccurs="0" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>Tuples</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Property Indexes</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="v" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="u" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unused Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Calculated Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Item Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cp" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="in" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Format Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>background Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>Foreground Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Italic</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Underline</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Strikethrough</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Bold</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_String">
    <xsd:sequence>
      <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>Tuples</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Property Index</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="v" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="u" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unused Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Calculated Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Item Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cp" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="in" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Format Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>Background Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional">
      <xsd:annotation>
        <xsd:documentation>Foreground Color</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Italic</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Underline</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Strikethrough</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Bold</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_DateTime">
    <xsd:sequence>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Member Property Index</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="v" use="required" type="xsd:dateTime">
      <xsd:annotation>
        <xsd:documentation>Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="u" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unused Item</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Calculated Item Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cp" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Member Property Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_FieldGroup">
    <xsd:sequence>
      <xsd:element name="rangePr" minOccurs="0" type="CT_RangePr">
        <xsd:annotation>
          <xsd:documentation>Range Grouping Properties</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="discretePr" minOccurs="0" type="CT_DiscretePr">
        <xsd:annotation>
          <xsd:documentation>Discrete Grouping Properties</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="groupItems" minOccurs="0" type="CT_GroupItems">
        <xsd:annotation>
          <xsd:documentation>OLAP Group Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="par" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Parent</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="base" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Field Base</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_RangePr">
    <xsd:attribute name="autoStart" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Source Data Set Beginning Range</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="autoEnd" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Source Data Ending Range</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="groupBy" type="ST_GroupBy" default="range">
      <xsd:annotation>
        <xsd:documentation>Group By</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="startNum" type="xsd:double">
      <xsd:annotation>
        <xsd:documentation>Numeric Grouping Start Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="endNum" type="xsd:double">
      <xsd:annotation>
        <xsd:documentation>Numeric Grouping End Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="startDate" type="xsd:dateTime">
      <xsd:annotation>
        <xsd:documentation>Date Grouping Start Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="endDate" type="xsd:dateTime">
      <xsd:annotation>
        <xsd:documentation>Date Grouping End Value</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="groupInterval" type="xsd:double" default="1">
      <xsd:annotation>
        <xsd:documentation>Grouping Interval</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:simpleType name="ST_GroupBy">
    <xsd:annotation>
      <xsd:documentation>Values Group By</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="range">
        <xsd:annotation>
          <xsd:documentation>Group By Numeric Ranges</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="seconds">
        <xsd:annotation>
          <xsd:documentation>Seconds</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="minutes">
        <xsd:annotation>
          <xsd:documentation>Minutes</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="hours">
        <xsd:annotation>
          <xsd:documentation>Hours</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="days">
        <xsd:annotation>
          <xsd:documentation>Days</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="months">
        <xsd:annotation>
          <xsd:documentation>Months</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="quarters">
        <xsd:annotation>
          <xsd:documentation>Quarters</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="years">
        <xsd:annotation>
          <xsd:documentation>Years</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:complexType name="CT_DiscretePr">
    <xsd:sequence>
      <xsd:element name="x" maxOccurs="unbounded" type="CT_Index">
        <xsd:annotation>
          <xsd:documentation>Element Group</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Mapping Index Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_GroupItems">
    <xsd:choice maxOccurs="unbounded">
      <xsd:element name="m" type="CT_Missing">
        <xsd:annotation>
          <xsd:documentation>No Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="n" type="CT_Number">
        <xsd:annotation>
          <xsd:documentation>Numeric Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="b" type="CT_Boolean">
        <xsd:annotation>
          <xsd:documentation>Boolean</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="e" type="CT_Error">
        <xsd:annotation>
          <xsd:documentation>Error Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="s" type="CT_String">
        <xsd:annotation>
          <xsd:documentation>Character Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="d" type="CT_DateTime">
        <xsd:annotation>
          <xsd:documentation>Date Time</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:choice>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Items Created Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotCacheRecords">
    <xsd:sequence>
      <xsd:element name="r" minOccurs="0" maxOccurs="unbounded" type="CT_Record">
        <xsd:annotation>
          <xsd:documentation>PivotCache Record</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 name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>PivotCache Records Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Record">
    <xsd:choice maxOccurs="unbounded">
      <xsd:element name="m" type="CT_Missing">
        <xsd:annotation>
          <xsd:documentation>No Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="n" type="CT_Number">
        <xsd:annotation>
          <xsd:documentation>Numeric Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="b" type="CT_Boolean">
        <xsd:annotation>
          <xsd:documentation>Boolean</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="e" type="CT_Error">
        <xsd:annotation>
          <xsd:documentation>Error Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="s" type="CT_String">
        <xsd:annotation>
          <xsd:documentation>Character Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="d" type="CT_DateTime">
        <xsd:annotation>
          <xsd:documentation>Date Time</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="x" type="CT_Index">
        <xsd:annotation>
          <xsd:documentation>Shared Items Index</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:choice>
  </xsd:complexType>
  <xsd:complexType name="CT_PCDKPIs">
    <xsd:sequence>
      <xsd:element name="kpi" minOccurs="0" maxOccurs="unbounded" type="CT_PCDKPI">
        <xsd:annotation>
          <xsd:documentation>OLAP KPI</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>KPI Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PCDKPI">
    <xsd:attribute name="uniqueName" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="optional" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Display Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="displayFolder" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Display Folder</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measureGroup" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Measure Group Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="parent" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Parent KPI</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="value" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Value Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="goal" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Goal Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="status" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Status Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="trend" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Trend Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="weight" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>KPI Weight Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="time" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Time Member KPI Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CacheHierarchies">
    <xsd:sequence>
      <xsd:element name="cacheHierarchy" minOccurs="0" maxOccurs="unbounded" type="CT_CacheHierarchy">
        <xsd:annotation>
          <xsd:documentation>PivotCache Hierarchy</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CacheHierarchy">
    <xsd:sequence>
      <xsd:element name="fieldsUsage" minOccurs="0" type="CT_FieldsUsage">
        <xsd:annotation>
          <xsd:documentation>Fields Usage</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="groupLevels" minOccurs="0" type="CT_GroupLevels">
        <xsd:annotation>
          <xsd:documentation>OLAP Grouping Levels</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 name="uniqueName" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="optional" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Display Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measure" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Measure Hierarchy</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="set" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Set</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="parentSet" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Parent Set</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="iconSet" type="xsd:int" default="0">
      <xsd:annotation>
        <xsd:documentation>KPI Icon Set</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="attribute" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Attribute Hierarchy</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="time" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Time</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="keyAttribute" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Key Attribute Hierarchy</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultMemberUniqueName" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Default Member Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allUniqueName" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Unique Name of 'All'</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Display Name of 'All'</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dimensionUniqueName" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Dimension Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="displayFolder" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Display Folder</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measureGroup" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Measure Group Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measures" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Measures</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="count" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Levels Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="oneField" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>One Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="memberValueDatatype" use="optional" type="xsd:unsignedShort">
      <xsd:annotation>
        <xsd:documentation>Member Value Data Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="unbalanced" use="optional" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unbalanced</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="unbalancedGroup" use="optional" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Unbalanced Group</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hidden" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Hidden</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_FieldsUsage">
    <xsd:sequence>
      <xsd:element name="fieldUsage" minOccurs="0" maxOccurs="unbounded" type="CT_FieldUsage">
        <xsd:annotation>
          <xsd:documentation>PivotCache Field Id</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_FieldUsage">
    <xsd:attribute name="x" use="required" type="xsd:int">
      <xsd:annotation>
        <xsd:documentation>Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_GroupLevels">
    <xsd:sequence>
      <xsd:element name="groupLevel" maxOccurs="unbounded" type="CT_GroupLevel">
        <xsd:annotation>
          <xsd:documentation>OLAP Grouping Levels</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Grouping Level Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_GroupLevel">
    <xsd:sequence>
      <xsd:element name="groups" minOccurs="0" type="CT_Groups">
        <xsd:annotation>
          <xsd:documentation>OLAP Level Groups</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 name="uniqueName" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Grouping Level Display Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="user" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>User-Defined Group Level</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="customRollUp" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Custom Roll Up</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Groups">
    <xsd:sequence>
      <xsd:element name="group" maxOccurs="unbounded" type="CT_LevelGroup">
        <xsd:annotation>
          <xsd:documentation>OLAP Group</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Level Group Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_LevelGroup">
    <xsd:sequence>
      <xsd:element name="groupMembers" type="CT_GroupMembers">
        <xsd:annotation>
          <xsd:documentation>OLAP Group Members</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="name" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Group Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueName" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Unique Group Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Group Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueParent" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Parent Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="id" type="xsd:int">
      <xsd:annotation>
        <xsd:documentation>Group Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_GroupMembers">
    <xsd:sequence>
      <xsd:element name="groupMember" maxOccurs="unbounded" type="CT_GroupMember">
        <xsd:annotation>
          <xsd:documentation>OLAP Group Member</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Group Member Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_GroupMember">
    <xsd:attribute name="uniqueName" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Group Member Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="group" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Group</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_TupleCache">
    <xsd:sequence>
      <xsd:element name="entries" minOccurs="0" type="CT_PCDSDTCEntries">
        <xsd:annotation>
          <xsd:documentation>Entries</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="sets" minOccurs="0" type="CT_Sets">
        <xsd:annotation>
          <xsd:documentation>Sets</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="queryCache" minOccurs="0" type="CT_QueryCache">
        <xsd:annotation>
          <xsd:documentation>OLAP Query Cache</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="serverFormats" minOccurs="0" maxOccurs="1" type="CT_ServerFormats">
        <xsd:annotation>
          <xsd:documentation>Server Formats</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:complexType>
  <xsd:complexType name="CT_ServerFormat">
    <xsd:attribute name="culture" use="optional" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Culture</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="format" use="optional" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Format</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_ServerFormats">
    <xsd:sequence>
      <xsd:element name="serverFormat" type="CT_ServerFormat" minOccurs="0" maxOccurs="unbounded">
        <xsd:annotation>
          <xsd:documentation>Server Format</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Format Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PCDSDTCEntries">
    <xsd:choice maxOccurs="unbounded">
      <xsd:element name="m" type="CT_Missing">
        <xsd:annotation>
          <xsd:documentation>No Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="n" type="CT_Number">
        <xsd:annotation>
          <xsd:documentation>Numeric Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="e" type="CT_Error">
        <xsd:annotation>
          <xsd:documentation>Error Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="s" type="CT_String">
        <xsd:annotation>
          <xsd:documentation>Character Value</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:choice>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Tuple Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Tuples">
    <xsd:sequence>
      <xsd:element name="tpl" type="CT_Tuple" minOccurs="1" maxOccurs="unbounded">
        <xsd:annotation>
          <xsd:documentation>Tuple</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="c" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Member Name Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Tuple">
    <xsd:attribute name="fld" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hier" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="item" type="xsd:unsignedInt" use="required">
      <xsd:annotation>
        <xsd:documentation>Item Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Sets">
    <xsd:sequence>
      <xsd:element name="set" maxOccurs="unbounded" type="CT_Set">
        <xsd:annotation>
          <xsd:documentation>OLAP Set</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Tuple Set Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Set">
    <xsd:sequence>
      <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>Tuples</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="sortByTuple" minOccurs="0" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>Sort By Tuple</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Number of Tuples</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="maxRank" use="required" type="xsd:int">
      <xsd:annotation>
        <xsd:documentation>Maximum Rank Requested</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="setDefinition" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>MDX Set Definition</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sortType" type="ST_SortType" default="none">
      <xsd:annotation>
        <xsd:documentation>Set Sort Order</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="queryFailed" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Query Failed</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:simpleType name="ST_SortType">
    <xsd:annotation>
      <xsd:documentation>Set Sort Order</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="none">
        <xsd:annotation>
          <xsd:documentation>None</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="ascending">
        <xsd:annotation>
          <xsd:documentation>Ascending</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="descending">
        <xsd:annotation>
          <xsd:documentation>Descending</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="ascendingAlpha">
        <xsd:annotation>
          <xsd:documentation>Ascending Alpha</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="descendingAlpha">
        <xsd:annotation>
          <xsd:documentation>Alphabetic Order Descending</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="ascendingNatural">
        <xsd:annotation>
          <xsd:documentation>Ascending Natural</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="descendingNatural">
        <xsd:annotation>
          <xsd:documentation>Natural Order Descending</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:complexType name="CT_QueryCache">
    <xsd:sequence>
      <xsd:element name="query" maxOccurs="unbounded" type="CT_Query">
        <xsd:annotation>
          <xsd:documentation>Query</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Cached Query Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Query">
    <xsd:sequence>
      <xsd:element name="tpls" minOccurs="0" type="CT_Tuples">
        <xsd:annotation>
          <xsd:documentation>Tuples</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="mdx" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>MDX Query String</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CalculatedItems">
    <xsd:sequence>
      <xsd:element name="calculatedItem" maxOccurs="unbounded" type="CT_CalculatedItem">
        <xsd:annotation>
          <xsd:documentation>Calculated Item</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Calculated Item Formula Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CalculatedItem">
    <xsd:sequence>
      <xsd:element name="pivotArea" type="CT_PivotArea">
        <xsd:annotation>
          <xsd:documentation>Calculated Item Location</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 name="field" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formula" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Calculated Item Formula</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CalculatedMembers">
    <xsd:sequence>
      <xsd:element name="calculatedMember" maxOccurs="unbounded" type="CT_CalculatedMember">
        <xsd:annotation>
          <xsd:documentation>Calculated Member</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Calculated Members Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_CalculatedMember">
    <xsd:sequence minOccurs="0">
      <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 name="name" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Calculated Member Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mdx" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Calculated Member MDX Formula</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="memberName" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>OLAP Calculated Member Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hierarchy" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="parent" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Parent Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="solveOrder" type="xsd:int" default="0">
      <xsd:annotation>
        <xsd:documentation>Calculated Members Solve Order</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="set" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Set</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_pivotTableDefinition">
    <xsd:sequence>
      <xsd:element name="location" type="CT_Location">
        <xsd:annotation>
          <xsd:documentation>PivotTable Location</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="pivotFields" type="CT_PivotFields" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>PivotTable Fields</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="rowFields" type="CT_RowFields" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Row Fields</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="rowItems" type="CT_rowItems" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Row Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="colFields" type="CT_ColFields" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Column Fields</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="colItems" type="CT_colItems" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Column Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="pageFields" type="CT_PageFields" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Page Field Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="dataFields" type="CT_DataFields" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Data Fields</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="formats" type="CT_Formats" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>PivotTable Formats</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="conditionalFormats" type="CT_ConditionalFormats" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>Conditional Formats</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="chartFormats" type="CT_ChartFormats" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>PivotChart Formats</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="pivotHierarchies" type="CT_PivotHierarchies" minOccurs="0">
        <xsd:annotation>
          <xsd:documentation>PivotTable OLAP Hierarchies</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="pivotTableStyleInfo" minOccurs="0" maxOccurs="1" type="CT_PivotTableStyle">
        <xsd:annotation>
          <xsd:documentation>PivotTable Style</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="filters" minOccurs="0" maxOccurs="1" type="CT_PivotFilters">
        <xsd:annotation>
          <xsd:documentation>Filters</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="rowHierarchiesUsage" type="CT_RowHierarchiesUsage" minOccurs="0" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Row OLAP Hierarchy References</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="colHierarchiesUsage" type="CT_ColHierarchiesUsage" minOccurs="0" maxOccurs="1">
        <xsd:annotation>
          <xsd:documentation>Column OLAP Hierarchy References</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 name="name" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cacheId" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>PivotCache Definition Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataOnRows" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Data On Rows</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataPosition" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Default Data Field Position</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attributeGroup ref="AG_AutoFormat" />
    <xsd:attribute name="dataCaption" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Data Field Header Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="grandTotalCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Grand Totals Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="errorCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Error Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showError" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Error</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="missingCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Caption for Missing Values</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showMissing" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Missing</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pageStyle" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Page Header Style Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pivotTableStyle" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Table Style Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="vacatedStyle" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Vacated Style</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="tag" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>PivotTable Custom String</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="updatedVersion" type="xsd:unsignedByte" default="0">
      <xsd:annotation>
        <xsd:documentation>PivotTable Last Updated Version</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minRefreshableVersion" type="xsd:unsignedByte" default="0">
      <xsd:annotation>
        <xsd:documentation>Minimum Refreshable Version</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="asteriskTotals" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Asterisk Totals</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showItems" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Item Names</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="editData" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Allow Edit Data</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="disableFieldList" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Disable Field List</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showCalcMbrs" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Calculated Members</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="visualTotals" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Total Visual Data</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showMultipleLabel" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Multiple Labels</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDataDropDown" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Drop Down</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDrill" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Expand Collapse</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="printDrill" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Print Drill Indicators</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showMemberPropertyTips" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Member Property ToolTips</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDataTips" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show ToolTips on Data</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableWizard" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Enable PivotTable Wizard</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableDrill" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Enable Drill Down</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="enableFieldProperties" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Enable Field Properties</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="preserveFormatting" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Preserve Formatting</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="useAutoFormatting" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Auto Formatting</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pageWrap" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Page Wrap</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pageOverThenDown" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Page Over Then Down</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalHiddenItems" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Subtotal Hidden Items</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowGrandTotals" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Row Grand Totals</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colGrandTotals" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Grand Totals On Columns</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fieldPrintTitles" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Field Print Titles</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="itemPrintTitles" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Item Print Titles</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mergeItem" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Merge Titles</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDropZones" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Drop Zones</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="createdVersion" type="xsd:unsignedByte" default="0">
      <xsd:annotation>
        <xsd:documentation>PivotCache Created Version</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="indent" type="xsd:unsignedInt" default="1">
      <xsd:annotation>
        <xsd:documentation>Indentation for Compact Axis</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showEmptyRow" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Empty Row</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showEmptyCol" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Empty Column</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showHeaders" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Field Headers</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="compact" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Compact New Fields</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outline" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Outline New Fields</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outlineData" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Outline Data Fields</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="compactData" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Compact Data</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="published" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Data Fields Published</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="gridDropZones" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Enable Drop Zones</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="immersive" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Stop Immersive UI</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="multipleFieldFilters" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Multiple Field Filters</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="chartFormat" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Chart Format Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowHeaderCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Row Header Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colHeaderCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Column Header Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fieldListSortAscending" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Default Sort Order</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mdxSubqueries" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>MDX Subqueries Supported</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="customListSort" type="xsd:boolean" use="optional" default="true">
      <xsd:annotation>
        <xsd:documentation>Custom List AutoSort</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Location">
    <xsd:attribute name="ref" use="required" type="ST_Ref">
      <xsd:annotation>
        <xsd:documentation>Reference</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="firstHeaderRow" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>First Header Row</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="firstDataRow" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>PivotTable Data First Row</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="firstDataCol" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>First Data Column</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rowPageCount" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Rows Per Page Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colPageCount" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Columns Per Page</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotFields">
    <xsd:sequence>
      <xsd:element name="pivotField" maxOccurs="unbounded" type="CT_PivotField">
        <xsd:annotation>
          <xsd:documentation>PivotTable Field</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotField">
    <xsd:sequence>
      <xsd:element name="items" minOccurs="0" type="CT_Items">
        <xsd:annotation>
          <xsd:documentation>Field Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="autoSortScope" minOccurs="0" type="CT_AutoSortScope">
        <xsd:annotation>
          <xsd:documentation>AutoSort Scope</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 name="name" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Field Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="axis" use="optional" type="ST_Axis">
      <xsd:annotation>
        <xsd:documentation>Axis</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataField" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Data Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalCaption" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Custom Subtotal Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDropDowns" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show PivotField Header Drop Downs</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hiddenLevel" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Hidden Level</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueMemberProperty" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Unique Member Property</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="compact" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Compact</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allDrilled" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>All Items Expanded</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional">
      <xsd:annotation>
        <xsd:documentation>Number Format Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outline" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Outline Items</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalTop" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Subtotals At Top</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToRow" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag To Row</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToCol" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag To Column</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="multipleItemSelectionAllowed" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Multiple Field Filters</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToPage" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag Field to Page</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToData" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Field Can Drag to Data</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragOff" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag Off</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showAll" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show All Items</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertBlankRow" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Insert Blank Row</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="serverField" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Server-based Page Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertPageBreak" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Insert Item Page Break</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="autoShow" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Auto Show</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="topAutoShow" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Top Auto Show</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hideNewItems" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Hide New Items</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measureFilter" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Measure Filter</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="includeNewItemsInFilter" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Inclusive Manual Filter</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="itemPageCount" type="xsd:unsignedInt" default="10">
      <xsd:annotation>
        <xsd:documentation>Items Per Page Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sortType" type="ST_FieldSortType" default="manual">
      <xsd:annotation>
        <xsd:documentation>Auto Sort Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataSourceSort" type="xsd:boolean" use="optional">
      <xsd:annotation>
        <xsd:documentation>Data Source Sort</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="nonAutoSortDefault" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Auto Sort</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rankBy" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Auto Show Rank By</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultSubtotal" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show Default Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sumSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Sum Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="countASubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>CountA</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="avgSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Average</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="maxSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Max Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="minSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Min Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="productSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Product Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="countSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDevSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>StdDev Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stdDevPSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>StdDevP Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="varSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Variance Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="varPSubtotal" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>VarP Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPropCell" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Member Property in Cell</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPropTip" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Member Property ToolTip</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPropAsCaption" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Show As Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultAttributeDrillState" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Drill State</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_AutoSortScope">
    <xsd:sequence>
      <xsd:element name="pivotArea" type="CT_PivotArea">
        <xsd:annotation>
          <xsd:documentation>Auto Sort Scope</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>
  <xsd:complexType name="CT_Items">
    <xsd:sequence>
      <xsd:element name="item" maxOccurs="unbounded" type="CT_Item">
        <xsd:annotation>
          <xsd:documentation>PivotTable Field Item</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Item">
    <xsd:attribute name="n" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Item User Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="t" type="ST_ItemType" default="data">
      <xsd:annotation>
        <xsd:documentation>Item Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="h" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Hidden</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="s" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Character</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sd" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Hide Details</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="f" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Calculated Member</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="m" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Missing</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="c" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Child Items</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="x" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Item Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="d" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Expanded</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="e" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drill Across Attributes</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PageFields">
    <xsd:sequence>
      <xsd:element name="pageField" maxOccurs="unbounded" type="CT_PageField">
        <xsd:annotation>
          <xsd:documentation>Page Field</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Page Item Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PageField">
    <xsd:sequence minOccurs="0">
      <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 name="fld" use="required" type="xsd:int">
      <xsd:annotation>
        <xsd:documentation>Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="item" use="optional" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Item Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hier" type="xsd:int">
      <xsd:annotation>
        <xsd:documentation>OLAP Hierarchy Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cap" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Display Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_DataFields">
    <xsd:sequence>
      <xsd:element name="dataField" maxOccurs="unbounded" type="CT_DataField">
        <xsd:annotation>
          <xsd:documentation>Data Field Item</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Data Items Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_DataField">
    <xsd:sequence>
      <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 name="name" use="optional" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Data Field Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fld" type="xsd:unsignedInt" use="required">
      <xsd:annotation>
        <xsd:documentation>Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotal" type="ST_DataConsolidateFunction" default="sum">
      <xsd:annotation>
        <xsd:documentation>Subtotal</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDataAs" type="ST_ShowDataAs" default="normal">
      <xsd:annotation>
        <xsd:documentation>Show Data As Display Format</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="baseField" type="xsd:int" default="-1">
      <xsd:annotation>
        <xsd:documentation>'Show Data As' Base Field</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="baseItem" type="xsd:unsignedInt" default="1048832">
      <xsd:annotation>
        <xsd:documentation>'Show Data As' Base Setting</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional">
      <xsd:annotation>
        <xsd:documentation>Number Format Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_rowItems">
    <xsd:sequence>
      <xsd:element name="i" maxOccurs="unbounded" type="CT_I">
        <xsd:annotation>
          <xsd:documentation>Row Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Items in a Row Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_colItems">
    <xsd:sequence>
      <xsd:element name="i" maxOccurs="unbounded" type="CT_I">
        <xsd:annotation>
          <xsd:documentation>Column Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Column Item Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_I">
    <xsd:sequence>
      <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X">
        <xsd:annotation>
          <xsd:documentation>Row / Column Item Index</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="t" type="ST_ItemType" default="data">
      <xsd:annotation>
        <xsd:documentation>Item Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="r" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Repeated Items Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="i" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Data Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_X">
    <xsd:attribute name="v" type="xsd:int" default="0">
      <xsd:annotation>
        <xsd:documentation>Shared Items Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_RowFields">
    <xsd:sequence>
      <xsd:element name="field" maxOccurs="unbounded" type="CT_Field">
        <xsd:annotation>
          <xsd:documentation>Row Items</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Repeated Items Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_ColFields">
    <xsd:sequence>
      <xsd:element name="field" maxOccurs="unbounded" type="CT_Field">
        <xsd:annotation>
          <xsd:documentation>Field</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Repeated Items Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Field">
    <xsd:attribute name="x" type="xsd:int" use="required">
      <xsd:annotation>
        <xsd:documentation>Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Formats">
    <xsd:sequence>
      <xsd:element name="format" maxOccurs="unbounded" type="CT_Format">
        <xsd:annotation>
          <xsd:documentation>PivotTable Format</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Formats Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Format">
    <xsd:sequence>
      <xsd:element name="pivotArea" type="CT_PivotArea">
        <xsd:annotation>
          <xsd:documentation>Pivot Table Location</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 name="action" type="ST_FormatAction" default="formatting">
      <xsd:annotation>
        <xsd:documentation>Format Action</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dxfId" type="ST_DxfId" use="optional">
      <xsd:annotation>
        <xsd:documentation>Format Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_ConditionalFormats">
    <xsd:sequence>
      <xsd:element name="conditionalFormat" maxOccurs="unbounded" type="CT_ConditionalFormat">
        <xsd:annotation>
          <xsd:documentation>Conditional Formatting</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Conditional Format Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_ConditionalFormat">
    <xsd:sequence>
      <xsd:element name="pivotAreas" type="CT_PivotAreas">
        <xsd:annotation>
          <xsd:documentation>Pivot Areas</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"></xsd:element>
    </xsd:sequence>
    <xsd:attribute name="scope" type="ST_Scope" default="selection">
      <xsd:annotation>
        <xsd:documentation>Conditional Formatting Scope</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="type" type="ST_Type" default="none">
      <xsd:annotation>
        <xsd:documentation>Conditional Formatting Rule Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="priority" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Priority</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotAreas">
    <xsd:sequence>
      <xsd:element name="pivotArea" minOccurs="0" maxOccurs="unbounded" type="CT_PivotArea">
        <xsd:annotation>
          <xsd:documentation>Pivot Area</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Pivot Area Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:simpleType name="ST_Scope">
    <xsd:annotation>
      <xsd:documentation>Conditional Formatting Scope</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="selection">
        <xsd:annotation>
          <xsd:documentation>Selection</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="data">
        <xsd:annotation>
          <xsd:documentation>Data Fields</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="field">
        <xsd:annotation>
          <xsd:documentation>Field Intersections</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:simpleType name="ST_Type">
    <xsd:annotation>
      <xsd:documentation>Top N Evaluation Type</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="none">
        <xsd:annotation>
          <xsd:documentation>Top N None</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="all">
        <xsd:annotation>
          <xsd:documentation>All</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="row">
        <xsd:annotation>
          <xsd:documentation>Row Top N</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="column">
        <xsd:annotation>
          <xsd:documentation>Column Top N</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:complexType name="CT_ChartFormats">
    <xsd:sequence>
      <xsd:element name="chartFormat" maxOccurs="unbounded" type="CT_ChartFormat">
        <xsd:annotation>
          <xsd:documentation>PivotChart Format</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Format Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_ChartFormat">
    <xsd:sequence>
      <xsd:element name="pivotArea" type="CT_PivotArea">
        <xsd:annotation>
          <xsd:documentation>Pivot Table Location Rule</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="chart" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Chart Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="format" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Pivot Format Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="series" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Series Format</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotHierarchies">
    <xsd:sequence>
      <xsd:element name="pivotHierarchy" maxOccurs="unbounded" type="CT_PivotHierarchy">
        <xsd:annotation>
          <xsd:documentation>OLAP Hierarchy</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>OLAP Hierarchy Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotHierarchy">
    <xsd:sequence>
      <xsd:element name="mps" minOccurs="0" type="CT_MemberProperties">
        <xsd:annotation>
          <xsd:documentation>OLAP Member Properties</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="members" minOccurs="0" maxOccurs="unbounded" type="CT_Members">
        <xsd:annotation>
          <xsd:documentation>Members</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 name="outline" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Outline New Levels</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="multipleItemSelectionAllowed" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Multiple Field Filters</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotalTop" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>New Levels Subtotals At Top</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showInFieldList" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Show In Field List</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToRow" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag To Row</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToCol" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag To Column</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToPage" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag to Page</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragToData" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Drag To Data</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dragOff" type="xsd:boolean" default="true">
      <xsd:annotation>
        <xsd:documentation>Drag Off</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="includeNewItemsInFilter" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Inclusive Manual Filter</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_RowHierarchiesUsage">
    <xsd:sequence>
      <xsd:element name="rowHierarchyUsage" minOccurs="1" maxOccurs="unbounded" type="CT_HierarchyUsage">
        <xsd:annotation>
          <xsd:documentation>Row OLAP Hierarchies</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Item Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_ColHierarchiesUsage">
    <xsd:sequence>
      <xsd:element name="colHierarchyUsage" minOccurs="1" maxOccurs="unbounded" type="CT_HierarchyUsage">
        <xsd:annotation>
          <xsd:documentation>Column OLAP Hierarchies</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Items Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_HierarchyUsage">
    <xsd:attribute name="hierarchyUsage" type="xsd:int" use="required">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Usage</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_MemberProperties">
    <xsd:sequence>
      <xsd:element name="mp" maxOccurs="unbounded" type="CT_MemberProperty">
        <xsd:annotation>
          <xsd:documentation>OLAP Member Property</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>OLAP Member Properties Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_MemberProperty">
    <xsd:attribute name="name" type="ST_Xstring" use="optional">
      <xsd:annotation>
        <xsd:documentation>OLAP Member Property Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showCell" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Cell</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showTip" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Show Tooltip</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showAsCaption" type="xsd:boolean" use="optional" default="false">
      <xsd:annotation>
        <xsd:documentation>Show As Caption</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="nameLen" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Name Length</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pPos" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Property Name Character Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pLen" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Property Name Length</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="level" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Level Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="field" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Members">
    <xsd:sequence>
      <xsd:element name="member" maxOccurs="unbounded" type="CT_Member">
        <xsd:annotation>
          <xsd:documentation>Member</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Item Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="level" use="optional" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Hierarchy Level</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Member">
    <xsd:attribute name="name" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Hidden Item Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_Dimensions">
    <xsd:sequence>
      <xsd:element name="dimension" minOccurs="0" maxOccurs="unbounded" type="CT_PivotDimension">
        <xsd:annotation>
          <xsd:documentation>OLAP Dimension</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>OLAP Dimensions Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotDimension">
    <xsd:attribute name="measure" type="xsd:boolean" default="false">
      <xsd:annotation>
        <xsd:documentation>Measure</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Dimension Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="uniqueName" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Dimension Unique Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Dimension Display Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_MeasureGroups">
    <xsd:sequence>
      <xsd:element name="measureGroup" minOccurs="0" maxOccurs="unbounded" type="CT_MeasureGroup">
        <xsd:annotation>
          <xsd:documentation>OLAP Measure Group</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Measure Group Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_MeasureDimensionMaps">
    <xsd:sequence>
      <xsd:element name="map" minOccurs="0" maxOccurs="unbounded" type="CT_MeasureDimensionMap">
        <xsd:annotation>
          <xsd:documentation>OLAP Measure Group</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Measure Group Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_MeasureGroup">
    <xsd:attribute name="name" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Measure Group Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="required" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Measure Group Display Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_MeasureDimensionMap">
    <xsd:attribute name="measureGroup" use="optional" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Measure Group Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dimension" use="optional" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Dimension Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotTableStyle">
    <xsd:attribute name="name" type="xsd:string">
      <xsd:annotation>
        <xsd:documentation>Table Style Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showRowHeaders" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Show Row Header Formatting</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showColHeaders" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Show Table Style Column Header Formatting</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showRowStripes" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Show Row Stripes</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showColStripes" type="xsd:boolean">
      <xsd:annotation>
        <xsd:documentation>Show Column Stripes</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showLastColumn" type="xsd:boolean" use="optional">
      <xsd:annotation>
        <xsd:documentation>Show Last Column</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotFilters">
    <xsd:sequence>
      <xsd:element name="filter" minOccurs="0" maxOccurs="unbounded" type="CT_PivotFilter">
        <xsd:annotation>
          <xsd:documentation>PivotTable Advanced Filter</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="count" type="xsd:unsignedInt" default="0">
      <xsd:annotation>
        <xsd:documentation>Pivot Filter Count</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:complexType name="CT_PivotFilter">
    <xsd:sequence>
      <xsd:element name="autoFilter" minOccurs="1" maxOccurs="1" type="CT_AutoFilter">
        <xsd:annotation>
          <xsd:documentation>Auto Filter</xsd:documentation>
        </xsd:annotation>
      </xsd:element>
      <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"></xsd:element>
    </xsd:sequence>
    <xsd:attribute name="fld" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="mpFld" type="xsd:unsignedInt" use="optional">
      <xsd:annotation>
        <xsd:documentation>Member Property Field Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="type" use="required" type="ST_PivotFilterType">
      <xsd:annotation>
        <xsd:documentation>Pivot Filter Type</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="evalOrder" use="optional" type="xsd:int" default="0">
      <xsd:annotation>
        <xsd:documentation>Evaluation Order</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="id" use="required" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Pivot Filter Id</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="iMeasureHier" use="optional" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Measure Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="iMeasureFld" use="optional" type="xsd:unsignedInt">
      <xsd:annotation>
        <xsd:documentation>Measure Field Index</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="name" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Pivot Filter Name</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="description" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Pivot Filter Description</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stringValue1" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Label Pivot</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="stringValue2" type="ST_Xstring">
      <xsd:annotation>
        <xsd:documentation>Label Pivot Filter String Value 2</xsd:documentation>
      </xsd:annotation>
    </xsd:attribute>
  </xsd:complexType>
  <xsd:simpleType name="ST_ShowDataAs">
    <xsd:annotation>
      <xsd:documentation>Show Data As</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="normal">
        <xsd:annotation>
          <xsd:documentation>Normal Data Type</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="difference">
        <xsd:annotation>
          <xsd:documentation>Difference</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="percent">
        <xsd:annotation>
          <xsd:documentation>Percentage Of</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="percentDiff">
        <xsd:annotation>
          <xsd:documentation>Percentage Difference</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="runTotal">
        <xsd:annotation>
          <xsd:documentation>Running Total</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="percentOfRow">
        <xsd:annotation>
          <xsd:documentation>Percentage of Row</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="percentOfCol">
        <xsd:annotation>
          <xsd:documentation>Percent of Column</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="percentOfTotal">
        <xsd:annotation>
          <xsd:documentation>Percentage of Total</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="index">
        <xsd:annotation>
          <xsd:documentation>Index</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:simpleType name="ST_ItemType">
    <xsd:annotation>
      <xsd:documentation>PivotItem Type</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="data">
        <xsd:annotation>
          <xsd:documentation>Data</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="default">
        <xsd:annotation>
          <xsd:documentation>Default</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="sum">
        <xsd:annotation>
          <xsd:documentation>Sum</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="countA">
        <xsd:annotation>
          <xsd:documentation>CountA</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="avg">
        <xsd:annotation>
          <xsd:documentation>Average</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="max">
        <xsd:annotation>
          <xsd:documentation>Max</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="min">
        <xsd:annotation>
          <xsd:documentation>Min</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="product">
        <xsd:annotation>
          <xsd:documentation>Product</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="count">
        <xsd:annotation>
          <xsd:documentation>Count</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="stdDev">
        <xsd:annotation>
          <xsd:documentation>stdDev</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="stdDevP">
        <xsd:annotation>
          <xsd:documentation>StdDevP</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="var">
        <xsd:annotation>
          <xsd:documentation>Var</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="varP">
        <xsd:annotation>
          <xsd:documentation>VarP</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="grand">
        <xsd:annotation>
          <xsd:documentation>Grand Total Item</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="blank">
        <xsd:annotation>
          <xsd:documentation>Blank Pivot Item</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:simpleType name="ST_FormatAction">
    <xsd:annotation>
      <xsd:documentation>PivotTable Format Types</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="blank">
        <xsd:annotation>
          <xsd:documentation>Blank</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="formatting">
        <xsd:annotation>
          <xsd:documentation>Formatting</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="drill">
        <xsd:annotation>
          <xsd:documentation>Drill Type</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="formula">
        <xsd:annotation>
          <xsd:documentation>Formula Type</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:simpleType name="ST_FieldSortType">
    <xsd:annotation>
      <xsd:documentation>Field Sort Type</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="manual">
        <xsd:annotation>
          <xsd:documentation>Manual Sort</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="ascending">
        <xsd:annotation>
          <xsd:documentation>Ascending</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="descending">
        <xsd:annotation>
          <xsd:documentation>Descending</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
  <xsd:simpleType name="ST_PivotFilterType">
    <xsd:annotation>
      <xsd:documentation>Pivot Filter Types</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
      <xsd:enumeration value="unknown">
        <xsd:annotation>
          <xsd:documentation>Unknown</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="count">
        <xsd:annotation>
          <xsd:documentation>Count</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="percent">
        <xsd:annotation>
          <xsd:documentation>Percent</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="sum">
        <xsd:annotation>
          <xsd:documentation>Sum</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionEqual">
        <xsd:annotation>
          <xsd:documentation>Caption Equals</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionNotEqual">
        <xsd:annotation>
          <xsd:documentation>Caption Not Equal</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionBeginsWith">
        <xsd:annotation>
          <xsd:documentation>Caption Begins With</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionNotBeginsWith">
        <xsd:annotation>
          <xsd:documentation>Caption Does Not Begin With</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionEndsWith">
        <xsd:annotation>
          <xsd:documentation>Caption Ends With</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionNotEndsWith">
        <xsd:annotation>
          <xsd:documentation>Caption Does Not End With</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionContains">
        <xsd:annotation>
          <xsd:documentation>Caption Contains</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionNotContains">
        <xsd:annotation>
          <xsd:documentation>Caption Does Not Contain</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionGreaterThan">
        <xsd:annotation>
          <xsd:documentation>Caption Is Greater Than</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionGreaterThanOrEqual">
        <xsd:annotation>
          <xsd:documentation>Caption Is Greater Than Or Equal To</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionLessThan">
        <xsd:annotation>
          <xsd:documentation>Caption Is Less Than</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionLessThanOrEqual">
        <xsd:annotation>
          <xsd:documentation>Caption Is Less Than Or Equal To</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionBetween">
        <xsd:annotation>
          <xsd:documentation>Caption Is Between</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="captionNotBetween">
        <xsd:annotation>
          <xsd:documentation>Caption Is Not Between</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueEqual">
        <xsd:annotation>
          <xsd:documentation>Value Equal</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueNotEqual">
        <xsd:annotation>
          <xsd:documentation>Value Not Equal</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueGreaterThan">
        <xsd:annotation>
          <xsd:documentation>Value Greater Than</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueGreaterThanOrEqual">
        <xsd:annotation>
          <xsd:documentation>Value Greater Than Or Equal To</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueLessThan">
        <xsd:annotation>
          <xsd:documentation>Value Less Than</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueLessThanOrEqual">
        <xsd:annotation>
          <xsd:documentation>Value Less Than Or Equal To</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueBetween">
        <xsd:annotation>
          <xsd:documentation>Value Between</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="valueNotBetween">
        <xsd:annotation>
          <xsd:documentation>Value Not Between</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateEqual">
        <xsd:annotation>
          <xsd:documentation>Date Equals</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateNotEqual">
        <xsd:annotation>
          <xsd:documentation>Date Does Not Equal</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateOlderThan">
        <xsd:annotation>
          <xsd:documentation>Date Older Than</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateOlderThanOrEqual">
        <xsd:annotation>
          <xsd:documentation>Date Older Than Or Equal</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateNewerThan">
        <xsd:annotation>
          <xsd:documentation>Date Newer Than</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateNewerThanOrEqual">
        <xsd:annotation>
          <xsd:documentation>Date Newer Than or Equal To</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateBetween">
        <xsd:annotation>
          <xsd:documentation>Date Between</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="dateNotBetween">
        <xsd:annotation>
          <xsd:documentation>Date Not Between</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="tomorrow">
        <xsd:annotation>
          <xsd:documentation>Tomorrow</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="today">
        <xsd:annotation>
          <xsd:documentation>Today</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="yesterday">
        <xsd:annotation>
          <xsd:documentation>Yesterday</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="nextWeek">
        <xsd:annotation>
          <xsd:documentation>Next Week</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="thisWeek">
        <xsd:annotation>
          <xsd:documentation>This Week</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="lastWeek">
        <xsd:annotation>
          <xsd:documentation>Last Week</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="nextMonth">
        <xsd:annotation>
          <xsd:documentation>Next Month</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="thisMonth">
        <xsd:annotation>
          <xsd:documentation>This Month</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="lastMonth">
        <xsd:annotation>
          <xsd:documentation>Last Month</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="nextQuarter">
        <xsd:annotation>
          <xsd:documentation>Next Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="thisQuarter">
        <xsd:annotation>
          <xsd:documentation>This Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="lastQuarter">
        <xsd:annotation>
          <xsd:documentation>Last Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="nextYear">
        <xsd:annotation>
          <xsd:documentation>Next Year</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="thisYear">
        <xsd:annotation>
          <xsd:documentation>This Year</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="lastYear">
        <xsd:annotation>
          <xsd:documentation>Last Year</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="yearToDate">
        <xsd:annotation>
          <xsd:documentation>Year-To-Date</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="Q1">
        <xsd:annotation>
          <xsd:documentation>First Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="Q2">
        <xsd:annotation>
          <xsd:documentation>Second Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="Q3">
        <xsd:annotation>
          <xsd:documentation>Third Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="Q4">
        <xsd:annotation>
          <xsd:documentation>Fourth Quarter</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M1">
        <xsd:annotation>
          <xsd:documentation>January</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M2">
        <xsd:annotation>
          <xsd:documentation>Dates in February</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M3">
        <xsd:annotation>
          <xsd:documentation>Dates in March</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M4">
        <xsd:annotation>
          <xsd:documentation>Dates in April</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M5">
        <xsd:annotation>
          <xsd:documentation>Dates in May</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M6">
        <xsd:annotation>
          <xsd:documentation>Dates in June</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M7">
        <xsd:annotation>
          <xsd:documentation>Dates in July</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M8">
        <xsd:annotation>
          <xsd:documentation>Dates in August</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M9">
        <xsd:annotation>
          <xsd:documentation>Dates in September</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M10">
        <xsd:annotation>
          <xsd:documentation>Dates in October</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M11">
        <xsd:annotation>
          <xsd:documentation>Dates in November</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
      <xsd:enumeration value="M12">
        <xsd:annotation>
          <xsd:documentation>Dates in December</xsd:documentation>
        </xsd:annotation>
      </xsd:enumeration>
    </xsd:restriction>
  </xsd:simpleType>
</xsd:schema>
ComplexTypes:
Elements:
	pivotCacheDefinition pivotCacheRecords pivotTableDefinition
SimpleTypes:
	ST_FieldSortType ST_FormatAction ST_GroupBy ST_ItemType ST_PivotFilterType ST_Scope ST_ShowDataAs ST_SortType ST_SourceType ST_Type
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0