IPrxSliceDimension.UseDSAggregationValue

Syntax

UseDSAggregationValue: Boolean;

Description

The UseDSAggregationValue property determines whether aggregation settings of the data source are used for this dimension in the regular report.

Comments

This property is relevant if the dimension is contained in the fixed area and the IsDSAggregationSupported property returns True. If this property is set to True, the aggregation method is the method that is specified in the aggregation settings for this dimension in the data source.

Example

Executing the example requires that the repository contains a regular report with the Report identifier.

Sub UserProc;
Var
    MB: IMetabase;
    Report: IPrxReport;
    Source: IPrxDataSource;
    Slice: IPrxSlice;
    Dim: IPrxSliceDimension;
Begin
    MB := MetabaseClass.Active;
    Report := MB.ItemById("Report").Edit As IPrxReport;
    For Each Source In Report.DataSources Do
        For Each Slice In Source.Slices Do
            For Each Dim In Slice.Dimensions Do
                If Dim.IsDSAggregationSupported And (Dim.Disposition = PrxHeaderDisposition.Fixed) Then
                    Dim.AggregationEnabled := TriState.OnOption;
                    Dim.UseDSAggregationValue := True;
                End If;
            End For;
        End For;
    End For;
    (Report As IMetabaseObject).Save;
End Sub UserProc;

After executing the example the system checks dimensions of slices of all data sources of the regular report. For the dimensions contained in the fixed area and having aggregation settings in a data source, data aggregation is allowed in the regular report. Aggregated data is to be calculated in accordance with aggregation settings in the data source.