ssml:cacheField

PivotCache Field

Element information

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

Schema document: sml-pivotTable.xsd

Type: ssml:CT_CacheField

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:sharedItems [0..1] Shared Items
2. ssml:fieldGroup [0..1] Field Group Properties
3. ssml:mpMap [0..*] Member Properties Map
4. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
name	[1..1]	ssml:ST_Xstring	PivotCache Field Name
caption	[0..1]	ssml:ST_Xstring	PivotCache Field Caption
propertyName	[0..1]	ssml:ST_Xstring	Property Name
serverField	[0..1]	xsd:boolean	Server-based Field	Default value is "false".
uniqueList	[0..1]	xsd:boolean	Unique List Retrieved	Default value is "true".
numFmtId	[0..1]	ssml:ST_NumFmtId	Number Format Id
formula	[0..1]	ssml:ST_Xstring	Calculated Field Formula
sqlType	[0..1]	xsd:int	SQL Data Type	Default value is "0".
hierarchy	[0..1]	xsd:int	Hierarchy	Default value is "0".
level	[0..1]	xsd:unsignedInt	Hierarchy Level	Default value is "0".
databaseField	[0..1]	xsd:boolean	Database Field	Default value is "true".
mappingCount	[0..1]	xsd:unsignedInt	Member Property Count
memberPropertyField	[0..1]	xsd:boolean	Member Property Field	Default value is "false".

Used in

Type ssml:CT_CacheFields (Element ssml:cacheFields)

Sample instance

<ssml:cacheField name="string">
   <ssml:sharedItems>
      <ssml:m>
         <ssml:tpls>...
         </ssml:tpls>
         <ssml:x/>
      </ssml:m>
   </ssml:sharedItems>
   <ssml:fieldGroup>
      <ssml:rangePr/>
      <ssml:discretePr>
         <ssml:x v="1"/>
      </ssml:discretePr>
      <ssml:groupItems>
         <ssml:m>...
         </ssml:m>
      </ssml:groupItems>
   </ssml:fieldGroup>
   <ssml:mpMap/>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:cacheField>