IPivotFilterSettings.AdditionalTableSourceSelSet

Syntax

AdditionalTableSourceSelSet: IDimSelectionSet

Description

The AdditionalTableSourceSelSet property returns the additional selection, according to which filtering is executed.

Comments

Filtering by additional selection is available if the UseAdditionalTableSource property is set to True.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier. The report data source contains three dimensions: the first is by rows, the second is by columns, and the third is fixed. The fixed dimension has the INDICATORS identifier.

Add links to the Dimensions, Express, Metabase, Pivot system assemblies.

Sub Button2OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Mb: IMetabase;
    Eax: IEaxAnalyzer;
    PivotFilter: IPivotFilter;
    FilterSelSet: IDimSelectionSet;
    FilterSel: IDimSelection;
Begin
    Mb := MetabaseClass.Active;
    Eax := Mb.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
    PivotFilter := Eax.Pivot.Filter;
    // Filter empty values
    PivotFilter.SuppressEmpty := True;
    // Filter zero values
    PivotFilter.SuppressZeros := True;
    // Enable filtering by additional selection in fixed dimensions
    PivotFilter.UseAdditionalTableSource := True;
    FilterSelSet := PivotFilter.AdditionalTableSourceSelSet;
    If FilterSelSet <> Null Then
        // Get dictionary and set selection for it
        FilterSel := FilterSelSet.FindById("INDICATORS");
        If FilterSel <> Null Then
            FilterSel.DeselectAll;
            FilterSel.SelectElement(FilterSel.Dimension.Elements.FindById("3"), False);
            Debug.WriteLine(FilterSel.ToString);
        End If;
    End If;
    (Eax As IMetabaseObject).Save;
End Sub Button2OnClick;

After executing the example, filtering of empty and zero values is enabled in the express report. Filtering by additional selection is enabled for the fixed dimension: the element with the specified identifier is selected, the filtering is executed by the data for the selected element and not by the actual express report selection.