Pivot > Pivot Assembly Interfaces > IPivotEvaluatorTotals > IPivotEvaluatorTotals.DataSourceTotalsDefined

IPivotEvaluatorTotals.DataSourceTotalsDefined

Syntax

DataSourceTotalsDefined: Boolean;

Description

The DataSourceTotalsDefined property returns whether there is the configured aggregation for data source facts.

Comments

The property returns True if an aggregation calculated on the server is set for data source facts. Any method, except for Count and CountDistinct, is used for aggregation.

Add a result with the PivotEvaluatorElementType.DataSource type to include aggregated data as a result that is calculated in the table.

Example

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

Sub UserProc;
Var
    MB: IMetabase;
    OLAP: IEaxAnalyzer;
    Pivot: IPivot;
    Totals: IPivotEvaluatorTotals;
Begin
    MB := MetabaseClass.Active;
    OLAP := MB.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
    Pivot := OLAP.Pivot;
    Totals := Pivot.Evaluator.Totals;
    If Totals.DataSourceTotalsDefined Then
        Totals.RowTypes := Totals.RowTypes + PivotEvaluatorElementType.DataSource;
    End If;
    Pivot.Refresh;
    (OLAP As IMetabaseObject).Save;
End Sub UserProc;

After executing the example a list of results that are calculated in express report is changed. If there are server aggregation settings for express report data source facts, a total is included into the list of totals that are calculated in express report by rows. The method of total result calculation corresponds with the method that is set in aggregation settings for data source facts.