IPivotFilterSettings.AttributeLinks

Syntax

AttributeLinks: IPivotFilterAttributeLinks;

Description

The AttributeLinks property returns filtering parameters by dimension attributes links.

Comments

This type of filtering enables the user to manage displayed data not by actual values in the cells, but by values of particular attributes of dimension elements. The established link works according to the same rule, which is used in working of controlling dimensions in cubes.

Filtering is executed as follows:

Element selection is set in the first dimension.
The A set of values is formed from values of the attribute determined by the IPivotFilterAttributeLink.FirstDimensionAttrId property.
The selected elements are obtained in the second dimension.
Among these elements the values of the attribute determined by the IPivotFilterAttributeLink.SecondDimensionAttrId property are selected that contain at least one value from the A list.
Data by the selected elements is kept in the table, data by other elements is hidden.

If after filtering there is no any element of the second dimension left for the first dimension element, this first dimension element is also excluded from the sample.

A link between two dimension is two-sided and depends on location of dimensions:

Fixed dimension filters dimension in the heading or sidehead.
The dimension, which is located above, filters those located under.
Links between dimension of the heading and sidehead are ignored.

Example

The property use is given in the example for IPivotFilterAttributeLinks.Add.