Each member from a different level of the same PivotTable cache hierarchy of this PivotTable named set is displayed in a separate PivotTable field (1).
"1"
All members from different levels of the same PivotTable cache hierarchy of this PivotTable named set are displayed in the same PivotTable field (1).
dynamicSet: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether this PivotTable named set is a dynamic OLAP named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").
Value
Meaning
"0"
This PivotTable named set is a static OLAP named set.
"1"
This PivotTable named set is a dynamic OLAP named set.
hierarchizeDistinct: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to automatically order and remove duplicates from this PivotTable named set. This attribute MUST NOT exist if the set attribute in the ancestor CT_CalculatedMember element is zero ("0").
