ssml:pivotHierarchies

PivotTable OLAP Hierarchies

Element information

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

Schema document: sml-pivotTable.xsd

Type: ssml:CT_PivotHierarchies

Properties: Local, Qualified

Content

ssml:pivotHierarchy [1..*] OLAP Hierarchy

Attributes

Name	Occ	Type	Description	Notes
count	[0..1]	xsd:unsignedInt	OLAP Hierarchy Count

Used in

Type ssml:CT_pivotTableDefinition (Element ssml:pivotTableDefinition)

Sample instance

<ssml:pivotHierarchies>
   <ssml:pivotHierarchy>
      <ssml:mps>
         <ssml:mp field="1"/>
      </ssml:mps>
      <ssml:members>
         <ssml:member name="string"/>
      </ssml:members>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:pivotHierarchy>
</ssml:pivotHierarchies>