IPivot.KeepDataMatrix

Syntax

KeepDataMatrix: Boolean;

Description

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

Comments

If the property is set to False, data matrix clearing and its further obtaining take place each time in case of changing data source properties, for example, in case of filtering setting, sorting, Pareto analysis, etc. If the property is set to True, data matrix clearing takes place only when needed.

Example

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

Sub Main;

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 Main;

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