2.1.783 Part 1 Section 18.10.1.72, pivotHierarchy (OLAP Hierarchy)

a.   The standard specifies @includeNewItemsInFilter value of 1 indicates the application will show only items the user has selected; all other items will be hidden.

Specification of the includeNewItemsInFilter attribute applies to member elements in the members children (there can be more than 1 members under pivotHierarchy) of this element and item elements, which have s equal to 1 or true and which are in pivotField element associated with this pivotHierarchy by the fieldsUsage element of the cacheHieararchy.

A value of 1, or true, indicates the specified members and items represent items that are excluded from the PivotTable, along with their descendants.

A value of 0, or false, indicates the specified members and items represent items that are included in the PivotTable, along with their ascendants and descendants.

b.   The standard specifies @dragToData indicates whether the user is allowed to put this hierarchy into the data area of the view.

Office specifies @dragToData value of indicates the user can put this hierarchy into the data area of the PivotTable, subject to other constraints that may apply.

c.   The standard specifies @dragToRow indicates whether the user is allowed to put this hierarchy into the row area of the PivotTable.

Office specifies @dragToRow value of 1 true indicates the user can put this hierarchy into the row area of the PivotTable, subject to other constraints that may apply.

d.   The standard does not specify a length limit for the caption attribute.

Office specifies a limit of less than or equal to 65535 characters for the caption attribute.

e.   The standard specifies @dragToPage indicates whether the user is allowed to put this hierarchy into the page area of the PivotTable.

Office specifies @dragToPage value of 1 indicates the user can put this hierarchy into the page area of the PivotTable, subject to other constraints that may apply.

f.   In the standard when @dragToCol is 0, this hierarchy cannot be removed.

Office specifies when @dragToCol is 0 the user cannot put this hierarchy into the column area of the PivotTable. When the value is 1 the user can put this hierarchy into the column area of the PivotTable, subject to other constraints that may apply.

Show: