IPivot.Drill

Syntax

Drill: IPivotDrill;

Description

The Drill property returns table data drilldown/drillup settings.

Comments

By default, drilldown/drillup are available for all data source dimensions. If required, the list of dimensions can be changed, the order of dimensions and selection strategy during drilldown/drillup can also be changed. Setup procedure is described in the Setting Up Drilldown subsection.

Example

Executing the example requires that the repository contains a regular report with the REPORT identifier. The report contains a data source, based on which an analytical data area is built. Column headers display the dimension that contains several element levels.

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

Sub UserProc;
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Pivot: IPivot;
    Drill: IPivotDrill;
    Dim: IDimInstance;
Begin
    Mb := MetabaseClass.Active;
    // Open report
    Report := Mb.ItemById("REPORT").Edit As IPrxReport;
    // Data area slice
    Pivot := (Report.DataArea.Slices.Item(0) As IEaxDataAreaPivotSlice).Pivot;
    // Column header dimension, by which drilldown will be allowed
    Dim := Pivot.TopHeader.Dim(0);
    // Drilldown settings
    Drill := Pivot.Drill;
    Drill.Dimensions.RemoveAll;
    Drill.Dimensions.AddNew(Dim.Key);
    Drill.SelectionStrategy := PivotDrillSelectionStrategy.Combine;
    // Save changes
    Report.MetabaseObject.Save;
End Sub UserProc;

After executing the example, drilldown settings are changed for analytical data area slice. First, all dimensions are removed from the list of dimensions, for which drilldown/drillup is available. Then, a dimension from the column header is added to the list.

See also:

IPivot