IPivot.KeepDataMatrix

Syntax

KeepDataMatrix: Boolean;

Description

The KeepDataMatrix property determines whether data matrix should be cleared after extracting data from it.

Comments

Available values:

True. Default value. Data matrix is cleared only if required.
False. Data matrix is cleared and obtained each time in case of changing data source properties, for example, in case of filtering setting, sorting, Pareto analysis, and so on.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier.

Sub UserProc;
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    Expr: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    MB := MetabaseClass.Active;
    MObj := MB.ItemById("EXPRESS_REPORT").Edit;
    Expr := MObj As IEaxAnalyzer;
    Pivot := Expr.Pivot;
    Pivot.KeepDataMatrix := False;
    MObj.Save;
End Sub UserProc;

After executing the example express report data matrix is cleared each time after extracting data from it.