ICubeExecuteSetup.StrictRequiredItems

Syntax

StrictRequiredItems: Boolean;

Description

The StrictRequiredItems property determines whether the data is extracted only by mandatory changes.

Comments

Available values:

True. Data is extracted only by mandatory dimensions.
False. Data is extracted by selected dimensions.

Example

Executing the example requires that the repository contains a time series database with the FC identifier.

Add links to the Metabase, Cubes, Dimensions and Matrix system assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Cat: IMetabaseObject;
    Inst: IRubricatorInstance;
    Cub: ICubeInstance;
    Dest: ICubeInstanceDestination;
    Exe: ICubeInstanceDestinationExecutor;
    Sels: IDimSelectionSet;
    Sel: IDimSelection;
    Arr: Array[1] Of Integer;
    Si, Sc: Integer;
    Mat: IMatrix;
    ExecuteResult: ICubeExecuteResult;
    It: IMatrixIterator;
    Coo: IMatrixCoord;
Begin
    Mb := MetabaseClass.Active;
    Cat := Mb.ItemById("FC").Bind;
    Inst := Cat.Open(Null) As IRubricatorInstance;
    Cub := Inst As ICubeInstance;
    Dest := Cub.Destinations.DefaultDestination;
    Sels := Dest.CreateDimSelectionSet;
    Sc := Sels.Count - 1;
    For Si := 0 To Sc Do
        Sel := Sels.Item(Si);
        Sel.SelectAll;
    End For;
    Exe := Dest.CreateExecutor;
    (Exe As IRubricatorFactorIO).MultipleFactors := True;
    Arr[0] := 125616;
    (Exe As IRubricatorFactorExecutor).SetFactorKeys(Arr);
    (Sels As ICubeExecuteSetup).StrictRequiredItems := True;
    Exe.PrepareExecute(Sels);
    Mat := Exe.Matrix;
    ExecuteResult := CubeClass.ExecuteResult(Mat);
    Exe.PerformExecute;
    Mat.ValueFlag := 1;
    Coo := Mat.CreateCoord;
    It := Mat.CreateIterator;
    It.Move(IteratorDirection.First);
    While It.Valid Do
        Debug.WriteLine(It.Value);
        It.Move(IteratorDirection.Next);
    End While;
End Sub UserProc;

After executing the example data by mandatory dimensions for time series with the 125616 key is obtained and displayed in the console window.