ssml:pivotCacheDefinition

PivotCache Definition

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-pivotTable.xsd

Type: ssml:CT_PivotCacheDefinition

Properties: Global, Qualified

Content

Sequence [1..1]
1. ssml:cacheSource [1..1] PivotCache Source Description
2. ssml:cacheFields [1..1] PivotCache Fields
3. ssml:cacheHierarchies [0..1] PivotCache Hierarchies
4. ssml:kpis [0..1] OLAP KPIs
5. ssml:tupleCache [0..1] Tuple Cache
6. ssml:calculatedItems [0..1] Calculated Items
7. ssml:calculatedMembers [0..1] Calculated Members
8. ssml:dimensions [0..1] OLAP Dimensions
9. ssml:measureGroups [0..1] OLAP Measure Groups
10. ssml:maps [0..1] OLAP Measure Group
11. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
r:id	[0..1]	r:ST_RelationshipId	Relationship Identifier
invalid	[0..1]	xsd:boolean	Invalid Cache	Default value is "false".
saveData	[0..1]	xsd:boolean	Save Pivot Records	Default value is "true".
refreshOnLoad	[0..1]	xsd:boolean	Refresh On Load	Default value is "false".
optimizeMemory	[0..1]	xsd:boolean	Optimize Cache for Memory	Default value is "false".
enableRefresh	[0..1]	xsd:boolean	Enable PivotCache Refresh	Default value is "true".
refreshedBy	[0..1]	ssml:ST_Xstring	Last Refreshed By
refreshedDate	[0..1]	xsd:double	PivotCache Last Refreshed Date
backgroundQuery	[0..1]	xsd:boolean	Background Query	Default value is "false".
missingItemsLimit	[0..1]	xsd:unsignedInt	Missing Items Limit
createdVersion	[0..1]	xsd:unsignedByte	PivotCache Created Version	Default value is "0".
refreshedVersion	[0..1]	xsd:unsignedByte	PivotCache Last Refreshed Version	Default value is "0".
minRefreshableVersion	[0..1]	xsd:unsignedByte	Minimum Version Required for Refresh	Default value is "0".
recordCount	[0..1]	xsd:unsignedInt	PivotCache Record Count
upgradeOnRefresh	[0..1]	xsd:boolean	Upgrade PivotCache on Refresh	Default value is "false".
tupleCache	[0..1]	xsd:boolean	Stores Cache for OLAP Functions	Default value is "false".
supportSubquery	[0..1]	xsd:boolean	Supports Subqueries	Default value is "false".
supportAdvancedDrill	[0..1]	xsd:boolean	Supports Attribute Drilldown	Default value is "false".

Sample instance

<ssml:pivotCacheDefinition>
   <ssml:cacheSource type="worksheet">
      <ssml:worksheetSource ref="string"/>
   </ssml:cacheSource>
   <ssml:cacheFields>
      <ssml:cacheField name="string">
         <ssml:sharedItems>...
         </ssml:sharedItems>
         <ssml:fieldGroup>...
         </ssml:fieldGroup>
         <ssml:mpMap/>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cacheField>
   </ssml:cacheFields>
   <ssml:cacheHierarchies>
      <ssml:cacheHierarchy uniqueName="string" count="1">
         <ssml:fieldsUsage>...
         </ssml:fieldsUsage>
         <ssml:groupLevels>...
         </ssml:groupLevels>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cacheHierarchy>
   </ssml:cacheHierarchies>
   <ssml:kpis>
      <ssml:kpi uniqueName="string" value="string"/>
   </ssml:kpis>
   <ssml:tupleCache>
      <ssml:entries>
         <ssml:m>...
         </ssml:m>
      </ssml:entries>
      <ssml:sets>
         <ssml:set maxRank="1" setDefinition="string">...
         </ssml:set>
      </ssml:sets>
      <ssml:queryCache>
         <ssml:query mdx="string">...
         </ssml:query>
      </ssml:queryCache>
      <ssml:serverFormats>
         <ssml:serverFormat/>
      </ssml:serverFormats>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:tupleCache>
   <ssml:calculatedItems>
      <ssml:calculatedItem>
         <ssml:pivotArea>...
         </ssml:pivotArea>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:calculatedItem>
   </ssml:calculatedItems>
   <ssml:calculatedMembers>
      <ssml:calculatedMember name="string" mdx="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:calculatedMember>
   </ssml:calculatedMembers>
   <ssml:dimensions>
      <ssml:dimension name="string" uniqueName="string" caption="string"/>
   </ssml:dimensions>
   <ssml:measureGroups>
      <ssml:measureGroup name="string" caption="string"/>
   </ssml:measureGroups>
   <ssml:maps>
      <ssml:map/>
   </ssml:maps>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:pivotCacheDefinition>