IMDCalculationCalculateArgs.SliceFilter

Syntax

SliceFilter(Slice: IMDCalculationSlice): IMDCalculationSliceFilter;

Parameters

Slice. Data consumer slice, by which element filtering must be set up.

Description

The SliceFilter property returns filtering settings of elements used in calculation.

Example

Executing the example requires that the repository contains multidimensional calculation on database server with the MDCalc_1 identifier. The data consumer contains the calendar dimension, on which a slice with the CALENDAR identifier is built.

Sub UserProc;
Var
    MB: IMetabase;
    MDInst: IMDCalculationInstance;
    Args: IMDCalculationCalculateArgs;
    Filter: IMDCalculationSliceFilter;
Begin
    MB := MetabaseClass.Active;
    MDInst := MB.ItemById("MDCalc_1").Open(Null) As IMDCalculationInstance;
    Args := MDInst.CreateCalculateArgs;
    //filter using Selection
    Filter := Args.SliceFilter(MDInst.Calculation.Destination.Slices.FindById("CALENDAR"));
    Filter.Type := MDCalculationSliceFilterType.Selection;
    Filter.Selection.SelectElement(0, True);
    Filter.Selection.SelectElement(32, True);
    MDInst.Calculate(Args);
End Sub UserProc;

After executing the example multidimensional calculation is executed on DB server. Calculation is executed by the selected elements containing formulas.

See also:

IMDCalculationCalculateArgs