AttributeLinks: IPivotFilterAttributeLinks;
AttributeLinks: Prognoz.Platform.Interop.Pivot.IPivotFilterAttributeLinks;
The AttributeLinks property returns filtering parameters by dimension attributes links.
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. Established link works according to the same rule, which is used in working of controlling dimensions in cubes.
Filtering is performed in the following way:
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.
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 items 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 ifrst dimension element is also excluded from the sample
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.
The property use is given in the example for IPivotFilterAttributeLinks.Add.
See also: