Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.1.813 Part 4 Section 3.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 states that on and off are valid values of the dragOff attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

d. The standard states that on and off are valid values of the dragToCol attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

e. The standard states that on and off are valid values of the dragToData attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

f. The standard states that on and off are valid values of the dragToPage attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

g. The standard states that on and off are valid values of the dragToRow attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

h. The standard states that on and off are valid values of the includeNewItemsInFilter attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

i. The standard states that on and off are valid values of the multipleItemSelectionAllowed attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

j. The standard states that on and off are valid values of the outline attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

k. The standard states that on and off are valid values of the showInFieldList attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

l. The standard states that on and off are valid values of the subtotalTop attribute.

Excel does not allow these values on this attribute.

This note applies to the following products: 2007, 2007 SP1, 2007 SP2.

m. 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.

n. 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.

o. 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.

p. 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:
© 2015 Microsoft